Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing >

Loading Sample Billing Files

You can now load the sample billing data provided with Oracle Self-Service E-Billing for testing purposes.

This task is a step in Roadmap for Installing the ETL Module for Oracle Self-Service E-Billing.

To load the sample billing files

1. Run the HierarchyCopy job in the Command Center for the period specified in the billing file.

   This job replicates the hierarchy version to the period that the ETL data file is for. Also run the Hierarchy Copy job if the new sample load file is for a new period.

   For details on running the HierarchyCopy job, see Administration Guide for Oracle Self-Service E-Billing.

2. If you are using the Telco version of Oracle Self-Service E-Billing, then copy the sample data files from the following directory to the ETL input directory. In the path, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.
   • UNIX. EDX_HOME\db\oracle\olap\etl\sample_data\Telco
   • Windows. EDX_HOME/db/oracle/olap/etl/sample_data\Telco

     Move the following sample Telco data files:

   • MASTER-DATA-FILE-20100509.DAT
   • EBILLING_B2B-DATA-FILE-20100510.DAT
   • EBILLING_B2B-DATA-FILE-20100512.DAT
   • EBILLING_B2B-DATA-FILE-20100551.DAT
   • EBILLING_B2B-DATA-FILE-20100552.DAT
   • EBILLING_B2B-DATA-FILE-20100553.DAT
   • EBILLING_B2B-DATA-FILE-20101101.DAT
   • EBILLING_B2B-DATA-FILE-20120528.DAT
   • EBILLING_B2B-DATA-FILE-20120618.DAT
   • EBILLING_B2B-DATA-FILE-20120630.DAT
   • EBILLING_B2C-DATA-FILE-20100516.DAT
   • EBILLING_B2C-DATA-FILE-20101101.DAT
   • EBILLING_B2C-DATA-FILE-20120528.DAT
   • EBILLING_B2C-DATA-FILE-20120618.DAT
   • EBILLING_B2C-DATA-FILE-20120630.DAT

     For consistency, it is recommended that you create the input directory in the same directory as the file locations previously defined in Oracle Warehouse Builder Design Center.

3. If you are using the Utility version of Oracle Self-Service E-Billing, then copy the sample data files from the following directory to the ETL input directory:
   • UNIX. EDX_HOME\db\oracle\olap\etl\sample_data\Utilities
   • Windows. EDX_HOME/db/oracle/olap/etl/sample_data/Utilities

     Move the following sample Utility data files:

   • MASTER-UTILITIES-20110101.DAT
   • EBILLING_B2C-UTILITIES-20110101.DAT
   • EBILLING_B2C-UTILITIES-20120528.DAT
   • EBILLING_B2C-UTILITIES-20120618.DAT
   • EBILLING_B2C-UTILITIES-20120630.DAT

     For consistency, it is recommended that you create the input directory in the same directory as the file locations previously defined in Oracle Warehouse Builder Design Center.

4. Log in to the Oracle Warehouse Builder Design Center as the repository owner.
   • Single Node Environment. Use the host name, port number, and SID for the Oracle Self-Service E-Billing database.
   • RAC Environment. Use SQL*Net Connection to log in to the Design Center, using the RAC Net Service Name, such as ebill, as the Net Service Name.
5. Start the Control Center from the Tools menu. Select Tools, Preferences, OWB, and then Deployment Menu. Make sure the Prompt for execution parameters option is enabled.
6. Expand the EBILLING_ETL_LOCATION, ETL_PF_MODULE, and ETL_SUP nodes.
7. Right click the EBILL_DATALOAD node (the ETL Loader job), and click Start. A dialog box might appear stating that the object must be deployed before execution. If this dialog appears, then click OK. Or you can run the ant command again from the following directory:
   • UNIX. EDX_HOME/db/oracle
   • Windows. EDX_HOME\db\oracle
8. You must remove sample data before going live. For information about the process of purging sample data, see Administration Guide for Oracle Self-Service E-Billing.

   CAUTION:  You must remove sample data from your production environment to comply with the Payment Card Industry Data Security Standard.