Thursday, August 28, 2008

Online Help Error

When logging into a manufactoring responsibility in Application 11i
and request help by clicking on "?" or Help>Oracle Applications Library,
receive the following message :

Oracle Applications Help Error
An error occurred while retrieving Oracle Applications Help information.
Target MSC:CONTENTS could not be found in the help tree.
Other resonsibilites work fine.


HELP -> Window Help

O.S. - SunSolaris


Set the profile Help system root in site level & Application Level for “ADVANCED SUPPLY CHAIN” from MSC:CONTENTS to FND:LIBRARY

Reference: Metalink Note:259298.1

Monday, August 25, 2008

Unable to login

When users are trying to login into oracle applications they are unable to login.
It shows the following error
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int)(userId=6,sessionMode='null','4DE538960900125FE040A8C00A016CCC24684017652941783825214968716732'); REASON = java.sql.SQLException: ORA-20001: Oracle error -20160: ORA-20160: Encountered an error while getting the ORACLE user account for your concurrent request.
Contact your system administrator.ORA-06512: at "APPS.ALR_FND_USER_UAR", line 1ORA-04088: error during execution of trigger 'APPS.ALR_FND_USER_UAR' has been detected in FND_SIGNON.NEW_ICX_SESSION.ORA-06512: at "APPS.APP_EXCEPTION", line 70ORA-06512: at "APPS.FND_SIGNON", line 18ORA-06512: at "APPS.FND_SIGNON", line 490ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 318ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 455ORA-06512: at line 1; ERRNO = 20001; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack( at oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack( at oracle.apps.fnd.framework.webui.OAPageBean.validateUser( at oracle.apps.fnd.framework.webui.OAPageBean.preparePage( at oracle.apps.fnd.framework.webui.OAPageBean.preparePage( at oracle.apps.fnd.framework.webui.OAPageBean.preparePage( at _oa__html._OA._jspService( at oracle.jsp.runtime.HttpJsp.service( at at oracle.jsp.JspServlet.doDispatch( at oracle.jsp.JspServlet.internalService( at oracle.jsp.JspServlet.service( at javax.servlet.http.HttpServlet.service( at org.apache.jserv.JServConnection.processRequest( at at ........

O.S. - HP-UX

To implement the solution, please execute the following steps:

Disable the trigger 'ALR_FND_USER_UAR' using sqlplus :

- SQL> alter trigger ALR_FND_USER_UAR disable;

- Retest Login.

Metalink suggest the following doc id's solution:
1) Note:388695.1
2) Note:357998.1
And Bouncing the Apache could resolve the error in some cases.

Sunday, August 24, 2008

Do not change the permissions for ".." directory which is available in every user home directory.. Changing the permission of that directory will change permission to the every user home directory as a result all users directories under "/home/" need to change