How to Create a Query-only Responsibility for HR

There is not a delivered responsibility that is query only but you can create one...

1. copy the seeded responsibility you want to use

2. in System Administrator responsibility, go to Profile > System

3. select your newly created responsibility in the Responsibility field

4. Select HR:Query Only Mode in the Profile field

5. set "HR:Query Only Mode" to "Yes" in the responsibility column

6. save

The new responsibility will have access to all the data but the user will not be able to update anything.

Error - Function Not Available To Responsibility

When attempting to create a form in custom module $XX_TOP ,the following error occurs:

"Function is not available for this responsibility.Contact your systemAdministrator or change the responsibility"

The cause for this is that the path for custom module is not defined the file $ORA_CONFIG_HOME/10.1.2/forms/server/default.env . When forms is running in servlet mode in a standard configuration the file $ORA_CONFIG_HOME/10.1.2/forms/server/default.env is read to determine the environment in which forms connnection are ran.
The location of the FMX files is determined by the value set for XX_TOP. If this location is not found the error as seen is raised.

To sovle the issue, perform the following steps:

1.Submit the "Compile Security" Concurrent program with the parameter everything set to Yes to verify that all the menu functions are compiled properly.

2.Create your-own AutoConfig template file

2.1 Define a product_top
Use the Oracle Applications Manager Context Editor to add your custom product_top to the context file. Refer to the Help pages available in Oracle Applications Manager. The relevant information for adding custom context variables is located in the "System Configuration"> "AutoConfig"> "Manage Custom Parameters" section. Choose the variable type "PROD_TOP" when adding the product_top variable. The default value for the product_top variable must be set to 's_at/product name/12.0.0'.
This will add the XX_TOP to the .xml file, so it picked up when the default.env is created by Autoconfig

3.Run AutoConfig

4.Restart apps services

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.