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 NOT updated' ); 

END IF; 

commit; 

END;

/

Also for advanced troubleshooting

 Enable debugging: 

a) Log into R12.2 middle tier and source the 'run' file system environment file. 

b) Backup file $INST_TOP/appl/admin/oacore_wls.properties 

c) Add following lines to $INST_TOP/appl/admin/oacore_wls.properties file (in all middle tiers, if needed) 

AFLOG_ENABLED=TRUE 

AFLOG_LEVEL=STATEMENT 

AFLOG_MODULE=% 

AFLOG_FILENAME=/tmp/Login.log (this is an example; just make sure that this is a writable directory) 

d) Bounce all middle tier services for change in steps #2 and #4 to take effect: 

$INST_TOP/admin/scripts/adstpall.sh 

$INST_TOP/admin/scripts/adstrtal.sh 

3> Reproduce the issue. This time you will receive "details" below the error message from the screenshot uploaded by you. 

Click on that and update the complete error message. 

Disable debugging:  Revert the files and bounce middle tier post issue fix