Upgrade Existing Business Area for Custom Listings

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.

Business area for the custom listing was redesigned in Oracle DMW 3.3. Existing business area that was created prior to release 3.3 are not compatible. Hence, you must upgrade the business area to align with the redesigned custom listing.

If you are upgrading from an existing Oracle DMW release 3.3.x to Oracle DMW release 3.4.2, upgrade the existing business area for custom listing.

1. Copy the file $CDR_TOP/patch/115/sql/cdrupgradeclba.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>/cdrupgradeclba.sql

   When prompted, enter the application user name. For example, Enter application user name:[e-mail].

   This script submits the CDR_UPGRADE_CLBA job.
4. To track if the CDR_UPGRADE_CLBA job is created:
   select job_name,state from DBA_SCHEDULER_JOBS where job_name='CDR_UPGRADE_CLBA';
5. To monitor the running status of the job while it is executing:
   SELECT job_name,session_id,running_instance FROM DBA_SCHEDULER_RUNNING_JOBS WHERE JOB_NAME = 'CDR_UPGRADE_CLBA';
6. After the job execution completes, to check the status of the job:
   select job_name,status,error#,additional_info from dba_scheduler_job_run_details where job_name='CDR_UPGRADE_CLBA' order by actual_start_date desc;
7. To extract the log file from the CDR_EXE_DEBUG table:
   select logentry from cdr_exe_debug where location='CDR_UPGRADE_CLBA' order by seq;