Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Update Profile option through sql script

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128

    Update Profile option through sql script

    -->Script can update the profile option at ('SITE', 'APPL', 'RESP', or 'USER'). Levels.
    --> Connect through Apps User
    Declare
    value Boolean;
    Begin
    value := fnd_profile.save('<Profile Short name>','0','<Level>');
    End;
    -->Then Query the profile from the same session and if the result is desired, you can commit the record.

    For Example update the Profile option "Sign On Password" at SITE Level.
    ---
    DECLARE
    stat boolean;
    BEGIN
    dbms_output.disable;
    dbms_output.enable(100000);
    stat := FND_PROFILE.SAVE('SIGNON_PASSWORD_NO_REUSE', '0', 'SITE');
    IF stat THEN
    dbms_output.put_line( 'Stat = TRUE - profile updated' );
    ELSE
    dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
    END IF;
    END;
    -------
    Note : Use the script only if the front end is not accessible.the recommended method to update any Profile Option is through Front End application.

    Hope this code will help you
    Last edited by Amit; 11-01-2011 at 02:58 PM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Updated script!!
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. Error while installing Apps 12.1 on OEL 5 Update 8
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 2
    Last Post: 09-03-2012, 08:22 PM
  2. how to skip an adpatch job in adctrl - use undocumented option 8
    By Amit in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-04-2011, 09:49 AM
  3. Query to find who and when update an Oracle Application Profile Options.
    By Amit in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-01-2011, 10:48 AM
  4. Query to get the Profile Value for a Profile Name
    By Amit in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-01-2011, 10:13 AM
  5. Maintain Snapshot Information to update and create Snapshots
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 10-30-2011, 10:21 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics