Administration Guide for Oracle Billing Insight > Loading Billing Data Into Oracle Billing Insight >

Loading Prepay Billing Files

You can optionally load prepay billing data into Oracle Billing Insight, using the LOADPREPAYFILE scenario in Oracle Data Integrator. The LOADPREPAYFILE process loads the prepay data into the OLAP staging tables, then automatically publishes the data load into the OLAP prepay fact table.

Before loading a prepay data file, the prepay account and service agreement numbers must exist in Oracle Billing Insight. For details, see Methods for Loading Provisioning Data. For information on how to provision the required data using Web Services, see Web Services Reference for Oracle Billing Insight.

It is recommended that you keep not more than three months of prepay data, as this could result in less efficient reporting analysis on the data. For details on how to purge prepay data, see Purging Unbilled and Prepay Data Records.

To load prepay data files

1. Log in to the Oracle Data Integrator as the repository owner.
2. On the Designer tab, expand Packages, and expand the LoadPrepayFile package.
3. Expand Scenarios, right-click on the LOADPREPAYFILE scenario, and click Run.
4. Select the ODIAgent from the Logical Agent drop-down list, and click OK.
5. In the Variable Values dialog, verify that that the default global variables are valid for this run. To change a value, uncheck the Latest Value check box, and enter the new value. Enclose all string values in single quotation marks.
   • 01_FileName_Pattern
   • 02_Input_Path
   • 03_Reject_Path
   • 04_Output_Path
   • 06_Auto_Reject

     For a description and details about values for each parameter, see Setting Global Variables and Email Passwords for ODI Processes.

6. Click OK.