Installation Guide for Oracle Billing Insight > Configuring the ODI Data Load Processes >

(Optional) Loading Sample Billing Files


Sample data is provided with Oracle Billing Insight for testing purposes.

CAUTION:  Loading sample data via scripts and sample billing file data is not supported in the same schema and can cause conflicts.

This task is a step in Roadmap for Configuring the Data Load Processes for Oracle Billing Insight.

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 data load 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 Billing Insight.

  2. If you are using the Telco version of Oracle Billing Insight, then copy the following sample data files from the following directory to the input directory for your data load process. In the path, EDX_HOME is the location where Oracle Billing Insight 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-001.DAT
    • EBILLING_B2B-DATA-FILE-001.DAT
    • EBILLING_B2B-DATA-FILE-002.DAT
    • EBILLING_B2B-DATA-FILE-003.DAT
    • EBILLING_B2B-DATA-FILE-004.DAT
    • EBILLING_B2B-DATA-FILE-005.DAT
    • EBILLING_B2B-DATA-FILE-006.DAT
    • EBILLING_B2B-UBDATA-FILE-001.DAT
    • EBILLING_B2C-CABLEDATA-FILE-001.DAT
    • EBILLING_B2C-CABLEDATA-FILE-002.DAT
    • EBILLING_B2C-CABLEDATA-FILE-003.DAT
    • EBILLING_B2C-CABLEDATA-FILE-004.DAT
    • EBILLING_B2C-CABLEDATA-FILE-005.DAT
    • EBILLING_B2C-CABLEDATA-FILE-006.DAT
    • EBILLING_B2C-DATA-FILE-001.DAT
    • EBILLING_B2C-DATA-FILE-002.DAT
    • EBILLING_B2C-DATA-FILE-003.DAT
    • EBILLING_B2C-DATA-FILE-004.DAT
    • EBILLING_B2C-DATA-FILE-005.DAT
    • EBILLING_B2C-DATA-FILE-006.DAT
    • EBILLING_B2C-PPDATA-FILE-001.DAT
    • EBILLING_B2C-PPDATA-FILE-002.DAT
    • EBILLING_B2C-PPDATA-FILE-003.DAT
    • EBILLING_B2C-UBDATA-FILE-001.DAT
  3. If you are using the Utility version of Oracle Billing Insight, then copy the sample data files from the following directory to the input directory for your data load process:
    • 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-001.DAT
    • EBILLING_B2B-UTILITIES-001.DAT
    • EBILLING_B2B-UTILITIES-002.DAT
    • EBILLING_B2B-UTILITIES-003.DAT
    • EBILLING_B2C-UTILITIES-001.DAT
    • EBILLING_B2C-UTILITIES-002.DAT
    • EBILLING_B2C-UTILITIES-003.DAT
  4. Use Oracle Data Integrator to run the data file load processes. For details, see Administration Guide for Oracle Billing Insight.
  5. You must remove sample data before going live. For information about the process of purging sample data, see Administration Guide for Oracle Billing Insight.

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

Installation Guide for Oracle Billing Insight Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices.