EBS : Login to application gets "unable to authenticate session" or "ORA-01403 error"

When we login to the application we get unable to authenticate session or ORA-01403 error

ERROR:

<PRE>Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session is no longer valid. </PRE> 

Servlet error: An exception occurred. The current application deployment descriptors do

Solution 1

1. Execute the following scripts from $FND_TOP/patch/115/sql as apps user:
SQL> @AFICXSMS.pls %
SQL> @AFICXSMB.pls %
2. Bounce the server.
3. Retest the issue.

Reference :Login Page Throws Error 1403: Java.Sql.Sqlexception: Ora-01403: No Data Found Ora-06512: At Line 1 H (Doc ID 1336030.1)


Solution 2:

 "Unable to authenticate session"

1. Open a new explorer window using its own session cookie by selecting File -> New Session from the Menu Bar in an existing browser window. (IE9 Users may have to enable the Menu Bar first by right clicking the browser header frame and selecting Menu Bar.)
2. Run from the command line adding the -noframemerging parameter
    e.g. Start -> Run -> iexplore -noframemerging
3. Create a new IE icon adding the -noframemerging parameter
    e.g. Start -> Program Files
4. Right click on the Internet Explorer icon and select Properties

5. Add -noframemerging to the end of the link in the Target field
    e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
6. Click the OK button to close the window

Reference : R12: Using IE8 to access two EBS Instances runs in error "Unable To Authenticate Session" (Doc ID 1098563.1)

Solution 3:

1. Go to Control Panel
2. Select Java Control Panel from the list.
3. From the popup window (Java Control Panel), uncheck "Enable the next-generation Java Plug-in" option.
4. Click "Apply" and click "OK"
5. Clear browsing history (Internet Explorer Menu Bar: Tools --> Delete Browsing History) and close all the browser sessions.
6. Open IE browser and try to access Oracle Applications, if the issue still persists reboot the system.

Solution 4:

Disable Internet Explorer add-ons:

• Click "Tools" and select "Internet Options".
• Click "Advanced" tab on the right.
• Under "Browsing", remove/uncheck the "Enable third-party browser extensions" check box.
• Click "OK" and close all opened Internet Explorer.
• Open New Internet Explorer