Grant DME_ERR_LOG to Workarea Schemas

Create a local copy of DME_ERR_LOG in all existing workarea schemas.

1. Copy the file $CDR_TOP/patch/115/sql/dmeCrLocalDmeErrTab.sql to a download directory.
2. Log in to SQL*Plus as the APPS database user.
3. Execute the script from the download directory:
   <download_directory>/dmeCrLocalDmeErrTab.sql

   When prompted, enter the value for one or more of the following parameters: Therapeutic Area, Study Name, Model Name, and Lifecycle.

   • If you provide input for the Therapeutic Area, Study Name, Model Name, and Lifecycle, the script creates the local dme_err_log table in the specific lifecycle work area of the model.
   • If you provide input for the Therapeutic Area, Study Name, and Model Name, the script creates the local dme_err_log table in all lifecycle work areas of the model.
   • If you provide input for the Therapeutic Area and Study Name, the script creates the local dme_err_log table in all lifecycle work areas of all the models in the specified study.
   • If you provide input for the Therapeutic Area, the script creates the local dme_err_log table in all lifecycle work areas of all the models in all the studies in the specified therapeutic area.
   • If you do not provide input for any of the parameters, the script creates the local dme_err_log table in all lifecycle work areas of all the models in all the studies in all the therapeutic area.