The PL/SQL scripts handle the parsing of events in the Oracle EBS database. The PL/SQL scripts configure database objects such as tables and procedures for data synchronization with the driver. If you don’t configure the database objects, the data communication might not work properly.
Installing the PL/SQL scripts includes performing the following tasks:
Installing the install_EBS.sql PL/SQL scripts in the Oracle EBS system.
Creating packages for the Publisher and Subscriber channels.
Locate the install_EBS.sql PL/SQL scripts from /mnt/products/IDM/scripts/OracleEBS installation directory and install them in the Oracle EBS system.
Log in to the Oracle SQL developer tool or Oracle database as a system user (Oracle EBS user name).
Run the install_EBS.sql command.
Copy the contents from the install_EBS.sql file and paste them in the Oracle SQL developer editor, then run the copied script to create the database tables.
Log out of the Oracle SQL developer tool or the Oracle database.
To create packages for the Publisher channel, do the following:
Log in to the Oracle SQL developer tool or Oracle database as an apps user.
In the left panel of the Oracle SQL developer tool, navigate to Packages and create a new package and name it IDM_DRIVER.
Add the publisher.pls script to the IDM_DRIVER package and save the package.
Right-click the IDM_DRIVER package, select create body and paste the contents of the publisher.pkb file from the Identity Manager installation directory.
Save the package.
Repeat this procedure for creating the IDM_DRIVER_S package for the Subscriber channel and add subsciber.pls and subsciber.pkb files from the Identity Manager installation directory to the package and save it.