Tuesday, December 22, 2020

How to set or change profile option values from EBS backend command lane

 To Change EBS profile options from the back end you can use below script 

in the below example we are setting a value for Profile option " APPS_SSO" to value "SSWA" at site level


login as apps user and execute below command 

SQL >

DECLARE

stat boolean;

BEGIN

dbms_output.disable;

dbms_output.enable(100000);

stat := FND_PROFILE.SAVE('APPS_SSO', 'SSWA', 'SITE');

IF stat THEN

dbms_output.put_line( 'Stat = TRUE - profile updated' );

ELSE

dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );

END IF;

commit;

END;

 /


PL/SQL procedure successfully completed.


No comments:

Post a Comment