Windchill EAI software components access distribution targets such as Oracle Applications instances via the user name (for example, ESISYS) and a password that are specified in the adapter configuration. To establish the security authorizations required by the TIBCO Adapter for Oracle Applications, you need the user name and password to connect to the APPS user (schema) of each distribution target database.

After installing the TIBCO Adapter for Oracle Applications, for each distribution target Oracle instance you must run the create_user_Mods.sql script in Oracle, as described in the Windchill Enterprise Systems Integration Installation and Configuration Guide - Oracle Applications, to set up the ESISYS database account used by the adapter.

You must also run the common_all_Mods.sql script in Oracle, as described in the Windchill Enterprise Systems Integration Installation and Configuration Guide - Oracle Applications, to give the grants on the required database objects for the ESISYS user.

To complete the adapter configuration, you must run a series of SQL scripts in Oracle to create the necessary TIBCO intermediate tables, stored procedures, and other Oracle-based TIBCO components. For more information, see the Windchill Enterprise Systems Integration Installation and Configuration Guide - Oracle Applications.