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