Run the Transformation Upgrade Script

Run the dmeupdxfmvalstat.sql script to ensure that Oracle DMW 2.5 populates the new status tracking table with the Validation status for Transformations created in an earlier version of Oracle DMW.

The script has a commit when the count of records it needs to insert or update goes beyond 500 records during the script run. If the script execution gets stopped mid-way or it loses the database connection, the next execution of this script upgrades the transformation records from where it stopped.

The script also generates a log file, for example, "dmeupdxfmvalstat_<YYYYMMDDHHMISS>.LST." The script displays the number of records in dme_xfm_val_status table after each commit statement. If it encounters any issues, you see errors display on the console. They also write to the log file.

Note:

Plan a maintenance window to run the script.

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/dmeupdxfmvalstat.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>/dmeupdxfmvalstat.sql

   Note:

   • After the script runs, it commits the records and automatically exits the database.
   • The script inserts debug messages into the cdr_exe_debug table with location = dmeupdxfmvalstat.sql. If debug was turned on, you can monitor the debug message to verify the script activity using following:

     SQL> select location, logentry from cdr_exe_debug where location = 'dmeupdxfmvalstat.sql' order by seq; 

   • You can monitor the records in the dme_xfm_val_status table to see if the count of records increased before and after the upgrade script execution. Run the following before and after upgrade script execution:

     SQL> select count(*) from dme_xfm_val_status;