How to assign SYSTEM ADMINISTRATOR Responsibility from backed BEGIN FND_USER_PKG.ADDRESP (‘ASSIGNEE_USERNAME_HERE’, ‘SYSADMIN’, ‘SYSTEM_ADMINISTRATOR’, ‘STANDARD’, ‘Add Sysadmin Responsibility to A user from Backend’, SYSDATE – 1, SYSDATE + 99 ); COMMIT; DBMS_OUTPUT.PUT_LINE (‘ Sysadmin responsibility a dded Successfully’); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ( ‘ This responsibility cannot be added: ‘ || SQLCODE || SUBSTR (SQLERRM, 1, 100) ); END; / OR BEGIN FND_USER_PKG.ADDRESP( USERNAME => 'ASSIGNEE_USER' , -- User Name -- <change it> RESP_APP => 'SYSADMIN' , -- Apps Short Name RESP_KEY ...
Posts
- Get link
- X
- Other Apps
Enable FND Diagnostics from SQL backed post enter password on login page below error Error Page - You have encountered an unexpected error. Please contact your System Administrator for assistance. set serveroutput on; begin if fnd_profile.save(X_NAME => 'FND_DIAGNOSTICS', X_VALUE => 'Y', X_LEVEL_NAME => 'SITE') then dbms_output.put_line('Profile Update Succeeded'); else dbms_output.put_line('Profile Update Failed'); end if; commit; end; or DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('FND_DIAGNOSTICS', 'Y', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NO...