Enable Click Here for Exception Details after login to EBS 12.1.3 instead of Homepage

After cloning the EBS Application, we faced issue while trying log in to the application. Log in information is validated, but instead of the Home page a blank screen appears and also the error message is not thrown. Generally in EBS Click Here for Exception Details will appear. On clicking the button we'll able to see the error stack and we plan for some workaround. In my case that Click Here message itself is not displayed. To bring that message, need to enable the Profile Option FND:Diagnostics = YES. Since we can't login to the application we'll achieve that form backend.


Step 1:

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


Step 2:

Re-attempt to login and click on "here" link to generate stack trace.

Step 3:

Go through the error message and based on that we can search for a solution.


****************************நன்றி****************************