Oracle E-Business Suite SQL Scripts

SQL scripts set up the infrastructure in the Oracle E-Business Suite database that is used by some of the features of the plug-in. You can use the scripts to create a plug-in user, grant privileges, revoke privileges, and alter the enabled editions of the plug-in user.

The following SQL scripts can help with your configuration of the basic settings of the plug-in:

• create_user.sql

  This script creates the database user that the plug-in uses to interact with the database. In this way, you can apply more detailed control over the privileges granted to the plug-in.

  For Oracle E-Business Suite 12.2.x, the created plug-in user is only used to issue SQL scripts for Oracle Concurrent Program, Custom Concurrent Program, and Oracle E-Business Event activities at run time.

  For Oracle E-Business Suite 12.1.x and 12.0.x, the created plug-in user is used to issue SQL scripts for all plug-in activities at run time.

• common_all.sql

  This script grants the plug-in user with privileges to access the Oracle Database Dictionary tables, Oracle Integration Repository tables, and Oracle Concurrent Program infrastructure packages and procedures. This script also creates the log table and SQL package used by the plug-in to record the progress and result of every transaction.

• common_all_undo.sql

  This script reverses all changes made by the common_all.sql script. After issuing this script, all privileges granted to the plug-in user are revoked, and the log tables and SQL packages used by the plug-in are deleted.

• user_upgrade.sql

  This script alters the enable editions of the plug-in user. Issue this script if you upgrade Oracle E-Business Suite 12.1.x to Oracle E-Business Suite 12.2.x.

Copyright © TIBCO Software Inc. All Rights Reserved.