Sunday, December 24, 2017

How to enable and disable Self Service Personal by script



Enable Disable Self-Service Personal by script





DECLARE
stat boolean;
BEGIN




dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('FND_DISABLE_OA_CUSTOMIZATIONS''Y''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;

Disable Disable Self-Service Personal by script





DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('FND_DISABLE_OA_CUSTOMIZATIONS''N''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;

No comments:

Post a Comment