Installation and Upgrade > Windchill ESI > Installing and Configuring Windchill ESI in an ORACLE Applications Environment > Using the Middleware Installation and Configuration Utility > Creating ESI User Accounts and Configuring Oracle for Windchill ESI > Configuring User, Responsibility, and Application for Object Processing
  
Configuring User, Responsibility, and Application for Object Processing
When installing the MasterConfiguration_OpenItem_all_Mods.sql script, you are prompted for values for user, responsibility, and application. These values are used by TIBCO to submit the Import Items concurrent request in the Oracle ERP system. The Import Item concurrent request is responsible for processing items using the Oracle Item Open Interface. The user, responsibility, and application values are used to set the security context of the Oracle ERP system. This needs to be done when connecting directly to the ERP system database instance, and allows the Import Items concurrent program to run with the appropriate permissions.
* 
You must have CREATE SYNONYM grants to execute this script.
The combination of user, responsibility, and application can be for any Oracle ERP user that can submit the Import Items concurrent program. The Import Items concurrent program is usually found on the main menu for the inventory responsibility. The navigation path is Items:Import:Import Items.
PTC recommends creating a new Oracle ERP system user, such as ESI, specifically for use with Windchill ESI. This allows information created byWindchill ESI to be easily tracked in the ERP system. Oracle retains user and timestamp information when creating or updating data. To view this information, navigate to the help menu of the main form, and select Record History.
PTC also suggests manually submitting the Import Items concurrent program with selected users to ensure the program is working properly. Any issues encountered when manually submitting the Import Items program affects Windchill ESI. The errors should be resolved before attempting to publish information using Windchill ESI.
To determine the values for user, responsibility, and application for use when running the MasterConfiguration_OpenItem_all_Mods.sql script, log into the Oracle ERP system with the user, and responsibility that you plan to use with Windchill ESI. Once logged in, select Help from the main menu, then select About Oracle Application. This displays a form that includes the user, responsibility, and application information. An example of the output from the About Oracle Applications window is shown:
Oracle Applications
Copyright� 1986-1999 Oracle Corporation,
Redwood Shores, California.
All Rights Reserved
----------------------------------------------------------
Login
----------------------------------------------------------
Site: PTC Operations
Application: Oracle Inventory
Responsibility: Inventory
Security Group: Standard
User Name: ESI
In the previous example, the values of ESI and Inventory get entered for Username and Responsibility when running the script. The value for Applications, however, needs to be translated to its short name before it can be entered.
The short name for an Application is displayed on the Application:Register form. To access the form, log into the Oracle ERP system as the System Administrator. Query the Application:Register form using the Application name that was displayed in your login information. In the previous example, the value of Oracle Inventory would be entered when querying the form. The resulting query would return a value of INV. When running the MasterConfiguration_OpenItem_all_Mods.sql script for the above example, the value for Application that would be entered is INV.