Run the Last Modification Column Script

The dmeupdlastmod.sql script adds the LAST_MODIFICATION column to existing business areas created in an earlier version of Oracle DMW. Excute it for studies with business areas created in 2.4.X or earlier. (You do not need to execute it for studies created in Oracle DMW 2.5 or multiple times per study.)

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

4. Provide one of the following at the Study Names prompt:
   • Single study name
   • Comma-delimited list of study names, for example, STUDY1,STUDY2 (240 characters maximum)
   • ALL (to process all studies)
5. Enter Y when prompted to continue. The script creates a log file (for example, dmeupdlastmod_<currenttimestamp>.log).
6. Review the log file and execute the script as needed for other studies.