Monday, January 5, 2009

Incorrect menu seeded with R12 causes error when iProcurement Catalog Administration is accessed

logging in to Oracle applications Release12 and selecting the iProcurement Catalog Administration responsibility immediately throws the following error

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Clicking the link for more details delivers the following:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: Definition name for type View Definition is invalid
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3111)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2908)
at _OA._jspService(_OA.java:232)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _OA._jspService(_OA.java:225)


This happens in a fresh install of R12 because an incorrect menu comes seeded for in seeded for the iProcurement Catalog Administration responsibility. The following work around can be used for getting rid of the error.

- Login to the application as a user which has the System Administrator responsibility.

- Navigate to Security/Responsibility/Define

- Query the responsibility - iProcurement Catalog Administration
* The menu is 'Internet Procurement eContent Manager' - which is incorrect

- Change the menu name to - 'iProcurement Administration: Catalog Administration Home'

- Logout and then again login, the problem will be resolved.


It is better to clear the Web Browser cache to eliminate all errors and correct the problem completely.

1 comment:

diana_ser said...

nice tool. However, I have heard about another program for how to install a .sql file into a mssql database, check it out and find out why it is more efficient