This post covers solution for the issue while trying to access Oracle forms in Oracle E-Business Suite (R12.2) & how to troubleshoot it with a complete solution.
So let’s first understand about Oracle Forms, it can be configured in two modes: servlet and socket.
In servlet mode, a Java servlet (called the Forms Listener servlet) manages the communication between the Forms Java client and the OracleAS Forms services. In socket mode, the desktop clients access the Forms server directly.
To know more about Oracle Forms check our post Oracle Apps R12 Forms: Servlet or Socket
We were trying to access System Administrator -> Define Profile Options but Java plugins were not working due to which forms are not opening:
Note: Apps 12 is based on Forms 10g and is configured to run in servlet mode by default.
1. Copy the URL that you are unable to open. In our case 1704ebs54.k21technologies.com:8000
2. Open Control panel, then search for Java and click on that.
3. Click on Security
4. Click the “Edit Site List…”
5. Click on Add and Paste the URL into the “Location” text box then click OK
6. Click continue on below screen
7. Click OK on Java Control Panel and reload the page.
If You Are On Window 10.
For Windows 10 with IE 11
- JRE 1.8.0_51 (64-bit) and higher
- JRE 1.7.0_85 (64-bit) and higher
Disable Smart Screen
- Follow website (https://www.zerodollartips.com/enable-or-disable-smartscreen-on-windows-10/) for instructions on how to disable Smart Screen in Windows 10
- If this didn’t work for you, go on to the next suggestion.
Enable App Side-loading
- Open up the Settings app, and navigate to Update & Security > For Developers
- Toggle Side-load apps
- If this doesn’t work, go on to the final suggestion
If you still unable to access then please do check the following
First of all, having so many versions of Java will cause issues with Oracle Forms, our suggestion would be is to reduce the Java to just one, say JRE 1.8.0_21 and uninstall the rest, it is always better to install only the 32 bit Java versions unless you have other application compatibility issues.
In case of IE error, carry out the same action plan which we did for adding security in JRE1.8 as well, that will solve the issue, please note that a restart of the browser is required for the changes to propagate.
Also, if you are using Firefox then, Firefox version greater than V52.0 which doesn’t support Oracle forms, so kindly uninstalls Firefox and then install a 32-bit Firefox of version 49 or 50. This will ensure that the forms are opened properly in Firefox.
After performing the above steps we were able to access Oracle Forms successfully without any issue.
- Recommended Browsers for Oracle E-Business Suite Release 12 [Doc ID 389422.1]
- [Troubleshooting] Forms Issue: FRM-92050 failed to connect to server:forms/servlet
- [Solved] Oracle EBS (R12) Installation Issue: Could not find the main class: oracle.apps.ad.rapidwiz.RIWizard
- Oracle AppsDBA (R12): Step by step Activity Guides
- Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain
This post is from our Oracle Apps DBA (R12.2) Training, in which we cover Architecture & Changes in Oracle E-Business Suite R12.2, Staging & Installation, File System & Important Files in R12.2, Start/Stop, Patching, AD Administration, Cloning, Concurrent Managers, AutoConfig, Password Management and Troubleshooting and much more
Next Task For You
Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Become an Oracle Apps DBA (R12) & Earn A Lot More In 2020.