This post covers solutions 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
Issue:
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.
Also check: Steps to download EBS R12 software from Edelivery Oracle site
Fix:
1. Copy the URL that you are unable to open. In our case 1704ebs54.k21technologies.com:8000
2. Open the 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.
Also read: ADOP (R12.2 Online Patching) in Oracle EBS (R12) FAQ
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.
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
Related/Further Readings
- [Troubleshooting] Forms Issue: FRM-92050 failed to connect to server:forms/servlet
- Oracle E-Business Suite (EBS) 12.2.9 Now Available & Its Upgrade Steps
- Steps to download Oracle E-Business Suite R12 Software
- Oracle AppsDBA (R12.2) Training: Step by Step Activity Guides/Hands-On Lab Exercise
- Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain
- Concurrent Managers: Overview & Concepts In Oracle EBS R12
- How to Change Apps/Applsys & sysadmin Schema Passwords in Oracle EBS R12.2 : Step by Step
- [Video] Online Patching (ADOP) In Oracle EBS R12.2
Next Task For You
We cover Oracle E-Business R12.2 Architecture & concepts in our Oracle Apps DBA For Beginners Training along with the Installation, Patching, Cloning, and Troubleshooting and also, Database upgrade to 19c and much more including the hands-on labs you must perform to upgrade your skills and get a good job with a high package.
Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Learn Oracle Apps DBA (R12) & It’s New Features.
Kalyan Y says
Thank you. It has worked for me on Windows10.
I got JRE 8 u 181.
Rahul Dangayach says
Hi Kalyan,
We are glad it helped!
Please stay tuned for further informative blogs.
Regards
Rahul
K21Academy
bhavisavla says
I am using Microsoft Edge v86 on a Windows 10 desktop. I have read microsoft edge is not certified to run forms using jre plugin and we need to configure JWS. However, we have multiple EBS instances, some of them seems to open forms while others don’t. All these instances have been cloned from the same production instance. Our desktop jre version is JRE 8 u191. Any idea what can cause this random behaviour?
EBS 12.2.4
Rahul Dangayach says
Hi Bhavisavla,
Please check the doc id for the same.
R12: Recommended Browsers for Oracle E-Business Suite (Doc ID 389422.1)
As per above article it requires jre 8 update 251 and above and requires other EBS patches for several known issues on top of edge.
Please refer to the article and carry out the mentioned fixes.
Thanks and Regards
Rahul Dangayach
Team K21 Academy
HOUSHMAND rastin says
With E-Business Suite 12.2.10, after implementing the Arabic language by applying the arabic 12.2.0 nls patch and then the 12.2.10 Arabic nls patch,
attempts to open any Arabic form are failing while all the US forms are operating normally.
After clicking on the menu item for an Arabic form, the user clicks on the menu item to open the form and it starts to open and then disappears from the screen. why?
ayyaz says
Hi,
I am facing the same issue. If you please found a solution, kindly let me know as well.