Enable FND : Diagnostics from backed if login page is not working in ebs r12.2

Hi,

Please find the steps below to enable trace for login page from backend if login page is inaccessible. 


FND: Diagnostics = Yes  : - 

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; 


2> 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. 


Trace will be logged in "/tmp/Login.log" and you can check this file for error details.