To update the already installed PL/SQL APIs, perform the following steps:
Log in to the Oracle SQL developer tool or Oracle database as an apps user.
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.
In the left panel of the Oracle SQL developer tool, navigate to Packages and search for the IDM_DRIVER package.
Replace the header of the IDM_DRIVER package with Publisher.pls and body with Publisher.pkb and save the package.
Navigate to Packages and search for the IDM_DRIVER_S package.
Replace the header of the IDM_DRIVER_S package with Subscriber.pls and body with Subscriber.pkb and save the package.