Monday, November 18, 2013

Forms Issues in R12 --- Oracle error 1403: java.sql.SQLException


ISSUE:1

If you come up with below error in the web browser while you are login into the Oracle Applications or the Application Forms do not load for a very long time,
"<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 not allow for including it in this response. Please consult the application log for details."


Solution 1:
Please implement below steps, to overcome the issue.
1. Go to Control Panel
Start à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. Launch the browser and try to access Oracle Applications, if the issue still persists reboot the system. 

Solution 2:
Disable Internet Explorer 8.0 add-ons:

a. Click "Tools" and select "Internet Options".
b. Click the "Advanced" tab on the right.
c. Under "Browsing", remove the "Enable third-party browser extensions" check box.
d. Click "OK" and close out of all instances of Internet Explorer.
e. Relaunch Internet Explorer.
 

Solution 3:
If you still see the above issue you can try this as well.

 "Unable to authenticate session"
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.)
Run from the command line adding the -noframemerging parameter e.g. Start -> Run -> iexplore -noframemerging
Create a new IE8 icon adding the -noframemerging parameter e.g.
Start -> Program Files
Right click on the Internet Explorer icon and select Properties
Add -noframemerging to the end of the link in the Target field e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
Click the OK button to close the window
This icon may then be copied to the desktop if desired

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