Run the Populate Custom Listings Script

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.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. For example:

   <download_directory>/dmepopqbenablestat.sql