My Oracle Support Banner

Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+) ( Framework and OSSWA) (Doc ID 342332.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Applications Framework - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Oracle Self-Service Web Applications - Version: 11.5.2 to 11.5.10
Information in this document applies to any platform.

Purpose

Introduction

This note is designed to help you investigate problems with logging into the Home Page with your Applications 11i system. (11.5.2 – 11.5.10+)

The fact you are unable to login to Oracle Applications 11i can be a symptom of a completely different underlying problem. So it is important you determine the root cause of the login failure.
The troubleshooting steps provided are intended to help reach that root cause. Login issues can be divided into 2 broad categories. The first category is where login page does not render at all. In other words the main page is completely inaccessible or unuseable. The second category of problem is issues encountered after entering a username & password combination. In this category are things like: errors received because the system is unable to process the login request, or after login the homepage is not rendered.

This note does NOT address issues that occur after a successful login; such as forms not launching or javascript errors when selecting a responsibility or missing responsibilities.

This note does NOT cover SSO or 10gAS login issues. (For SSO/Portal issues see Note:146469.1 , Note:233436.1, Note:186981.1)

Throughout the history of 11i the login process has undergone several changes. In order to provide the most comprehensive troubleshooting guide possible we will include all things that need to be checked. Some of these may not be applicable for your version of Oracle Apps.

Where the check requires a specific version this will be indicated…. If you are unsure of your version, do the check and report the results.

Some of the recent changes in the login process include:
As of FND.G / 11.5.9 maintenance pack, there is a new URL to launch Applications, namely:
http://<host name>.<domain name>:<HTTP port>/oa_servlets/AppsLogin
See Note:226825.1 - Release 11i, Oracle Application Object Library Mini-pack FND.G

As of 11.5.10.CU2 the ICXINDEX.htm page has been modified to re-direct you to oa_servlets/AppsLogin

Approach to Troubleshooting

Error messages will not necessarily indicate the root cause of the problem so it is important to collate information on the scope and nature of the problem.

• Was it working previously? If so, what has changed, are all the Server processes running?
• Are all users affected? If not, what is common link to users with problem?
• If this is a single user issue, does it only affect the one PC or user id? What are the user level profile options for this particular user?
• Is the problem confined to one network segment or one PC?
• Do you get different behaviour in Internet Explorer to Netscape browser?
• What is your instance architecture? Are you using load balancing, RAC, SSO, etc.?

 The troubleshooting tips below have been split into the quick checks that can be done easily on the fly, and detailed checks that may involve bouncing servers and may require editing files/packages so will need to ensure they can be restored if required.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 1. Validate TNS Connectivity
 2. Determine the DBC file in use and make sure it is valid:
 3. Is the web server running and able to render static html?
 4. (11.5.2-11.5.9) Check that the CGI environment and mod_plsql is functioning
 5. Ensure that JDK is installed correctly & is a certified version.
 6. Use the following programs to verify the installation and check that the servlets are functioning.
 7. Validate that jsp work.
 8. Check the "session.topleveldomain" setting in the
 9. Check the profile options
 10. To support non-US character sets,
 11. Is the system in Maintenance Mode?
 12. Are there any additional errors other than that reported directly on screen?
 13. Check browser settings:
 14. Are there any uncomitted changes in your Autoconfig context file? Run:
 15. For Windows ONLY:
 16. Do you have any symbolic links in your installed file system?
 17. Check the GUEST user information.
 18. Run the following script to ensure there are no invalid objects:
 19. Check Tablespace free space:
 20. Review your Alert.log.
 21. Review any database trace files.
 22. Validate the FND_NODES table:
 23. Validate the FND_ENABLED_PLSQL table
 24. Validate the 'ICX_SESSIONS_S' synonym
 25. Ensure ICX module is showing as an "Installed" module.
 26. Validate the ICX_PARAMETERS table.
 27. Check for Bug:3275654
 28. Oracle 8i ONLY do the following sql:
 29. Disable all personalizations on the homepage
 30. You can turn on OA Framework diagnostics logging in several ways
 31. Enable detailed logging in iAS
 32.Temporarily enable iAS to use symbolic links.
 33. Clear the iAS cache.
 34. Check the sqlnet.ora setup in the database Oracle Home.
 35. Modify AppsLocalLogin.jsp to trap exceptions.
 37. Check file permissions are not causing any problems.
 38. Regenerate JAVA_TOP:
 39. Generate database trace and SQL*Net traces.
 Appendix A Profile Option Query
 Appendix B - FND Enable Plsql Query
 Appendix C - Setting up detailed logging on the web server:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.