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

Loading Postpay Billing Files

You load your billing data into Oracle Billing Insight using the LOADPOSTPAYFILE scenario in Oracle Data Integrator. The LOADPOSTPAYFILE scenario loads the billing data into the OLAP database, then publishes the data load into the OLAP and OLTP production tables.

You can optionally run the LOADPOSTPAYFILE scenario without publishing the billing load, called the manual publish option. The manual option keeps the data in the OLAP work-in-process (WIP) tables and does not publish the data to production. If you use the manual option, then you must verify the data and run either the REJECTFILE scenario, or run the COMPLETELOAD scenario to accept the data and complete the data load publishing process. For details, see Rejecting Billing Files and Publishing a Data Load Manually.

Load the postpay file after loading the associated master file data. For details, see Loading Master Files.

If grouping is used, then you also have the option to perform a validation on the billing file to be loaded for a group. This option validates the company-to-group key or account-to-group key for the file if you are using grouping. By default, the job does not perform a validation.

CAUTION:  If you use grouping and run the LOADPOSTPAY scenario using the validation option, then you might experience a degradation in performance.

If you load unbilled data into Oracle Billing Insight, then the LOADPOSTPAYFILE scenario also removes unbilled data records.

To load a postpay billing file into Oracle Billing Insight

1. Log in to the Oracle Data Integrator as the repository owner.
2. On the Designer tab, expand Packages, and expand the LoadPostPayFile package.
3. Expand Scenarios, right-click on the LOADPOSTPAYFILE 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
   • 05_Publish
   • 06_Auto_Reject
   • 14_Validate_GroupKey

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

6. Click OK on the information screen.