Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.0.4 > Process of Migrating Oracle Self-Service E-Billing 6.0.3 to 6.0.4 >

Migrating Batch Reports from Oracle Self-Service E-Billing 6.0.3 to 6.0.4

Once you have successfully migrated from Oracle Self-Service E-Billing 6.0.3 to 6.0.4, you must copy the batch reports to the directory you want to use for reports in the 6.0.4 installation.

If you copy the reports to a different location than you used in version 6.0.3, you must update the batch report file location in the OLTP database. Also, if you install Oracle Self-Service E-Billing 6.0.4 in a location other than the default EDX_HOME, or if you create a custom subdirectory for storing batch reports and do not use the default output/reportapp, you must update the related properties in the reporting.batch.xma.xml file.

This task is a step in Process of Migrating Oracle Self-Service E-Billing 6.0.3 to 6.0.4.

To migrate your batch reports from Oracle Self-Service E-Billing 6.0.3 to version 6.0.4

1. On the application server, copy your existing batch reports to EDX_HOME\output\reportapp, where EDX_HOME is the directory where you installed Oracle Self-Service E-Billing 6.0.4. Copying the batch reports to the same location in each version maintains the existing OLTP database links to the reports.
2. If you copy your batch reports to a different file location in version 6.0.4 than you used in 6.0.3, you must update the batch report file location in the OLTP database. Log on to the OLTP schema using SQL*Plus, and run the following script:

   update edx_rpt_batch_report set file_location = 'NEW_LOCATION' || substr(file_location,length('OLD_LOCATION')+1) where file_location is not null;

   SQL>commit;

   where:

   • NEW_LOCATION is the new location where you will store batch reports in Oracle Self-Service E-Billing 6.0.4.
   • OLD_LOCATION is the old location where you stored batch reports in Oracle Self-Service E-Billing 6.0.3

     For example:

   SQL> update edx_rpt_batch_report set file_location = '/export/home/oracle/eBilling604/output/reportapp' || substr(file_location,length('/export/home/oracle/eBilling/output/reportapp')+1) where file_location is not null;

   SQL>commit;

3. If you install Oracle Self-Service E-Billing 6.0.4 in a directory other than the default EDX_HOME, or if you plan to use a customized batch report location (the default is output/reportapp), you must update the properties in the EDX_HOME/xma/config/com/edocs/common/reporting/reporting.batch.xma.xml file. Specify your installation root directory in the rootDir property, and specify the custom report subdirectory in the path property (report files are stored in rootDir/path):

   <!-- use this property to override the default base, the system property for edx.home

   <property name="rootDir"><value>C:/edocs</value></property>

   -->

   <property name="path">

   <value>/output/reportapp</value>

   </property>