Login failed for few users in oracle ebs R12.2.4

Dear Brothers/Sisters,

This issue happened only to few of the users. I could not find any error in application logs to figure out root cause.

Try the below once before you actually fixing the issue. Sometime the below help if there is no setup related issue.

1) Stop application $ADMIN_SCRIPTS_HOME/adstpall.sh
re-compile JSP pages

perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2 -log /tmp/ojspc_error.log

Start application $ADMIN_SCRIPTS_HOME/adstrtal.sh

Retest issue .


But in my case i had to do the below to figure out the issue.

2)

Is it possible to enable FNS_debug log on any user then provide fnd log by following steps
FND Debug Steps

1) Set below profile options on user level

FND: Debug Log Enabled YES
FND: Debug Log Filename NULL
FND: Debug Log Level STATEMENT
FND: Debug Log Module %

Provide fnd.wf.worklist% in module for mobile apps else keep %

2) SELECT MAX(LOG_SEQUENCE) before_seq
FROM FND_LOG_MESSAGES;

3) Run your test case/ Produce issues

4) SELECT MAX(LOG_SEQUENCE) after_seq
FROM FND_LOG_MESSAGES;

5) Retrieve error messages and save in Excel format.

SELECT module, message_text
FROM fnd_log_messages
WHERE log_sequence between &before_seq and &after_seq
ORDER BY log_sequence;


Found the below in excel sheet :


fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log

Oracle error -1654: ORA-01654: unable to extend index APPLSYS.FND_LOGINS_N2 by 16 in tablespace APPS_TS_ARCHIVE has been detected in FND_SIGNON.AUDIT_USER.


fnd.plsql.FND_SESSION_MANAGEMENT.createSessionPrivate


Exception:-20001 ORA-20001: Oracle error -20001: ORA-20001: Oracle error -1654: ORA-01654: unable to extend index APPLSYS.FND_LOGINS_N2 by 16 in tablespace APPS_TS_ARCHIVE has been detected in FND_SIGNON.AUDIT_USER. has been detected in FND_SIGNON.NEW_PROXY_ICX_SESSION.

- Error is due to No space in one of the tablespace. This bigger step could have been avoided if i just have looked into DB alert log. I was chasing behind everything instead of DB alert log :-)

I found this step is really helpful when i thought what if there is no error in DB. I would be happy if it helps someone. It will be appreciated any feedback about this blog.

Thanks!
~Sikky