Run the Populate Custom Listings Script

Note:

Do not perform this task if you are upgrading from release 3.4.x to 3.4.2 as you would have already performed it when you had installed or upgraded to release 3.4.x.

Run the dmepopqbenablestat.sql script to ensure that Oracle DMW populates the new custom listing status tracking table with the status for the custom listings you created in an earlier versions of Oracle DMW. Plan a maintenance window to run the script.

Note:

Run this script only if you are upgrading to Oracle DMW 3.4.2 from a release prior to 3.3.

Follow these steps to run the script on a computer with an Oracle client that can connect to the Oracle DMW database server using SQLPlus:

1. Download the file from $CDR_TOP/patch/115/sql/dmepopqbenablestat.sql.
2. Log in to SQLPlus (not SQLDeveloper) as the APPS database user.
3. Invoke the script from your download directory:

   <download_directory>/dmepopqbenablestat.sql