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

Loading Unbilled Files

You can optionally load unbilled data transactions into Oracle Billing Insight. ODI loads the unbilled data into the OLAP staging tables, then automatically publishes the data load into the OLAP unbilled fact table.

Before running the unbilled load process, the unbilled company, account, service agreement, and hierarchy (Business Edition) data must exist in Oracle Billing Insight. For information about provisioning data, see Methods for Loading Provisioning Data. For information on provisioning the required data using Web Services, see Web Services Reference for Oracle Billing Insight.

Successfully loaded unbilled data is eventually removed by the billing file (postpay) load process. When loading a billed file, the process also removes unbilled records for the service number account number combination being loaded. To be removed, the unbilled data must also be less than or equal to the bill cycle end date of the incoming billed file. (If the bill cycle end date is not present, then statement date is used.) If, for any reason, old unbilled data records do not get removed by the subsequent postpay billing load, you can purge the data records. For details, see Purging Unbilled and Prepay Data Records.

To load unbilled data

1. Verify that the required company, account, service agreement, and hierarchy (for B2B) data for the unbilled data file have been provisioned in Oracle Billing Insight.
2. Log in to the Oracle Data Integrator as the repository owner.
3. On the Designer tab, expand Packages, and expand the LoadUnbilledFile package.
4. Expand Scenarios, right-click on the LOADUNBILLEDFILE scenario, and click Run.
5. Select the ODIAgent from the Logical Agent drop-down list, and click OK.
6. 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.

7. Click OK.