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

Rejecting Billing Files

You can manually reject a file that fails to load properly. Rejecting a file removes the previously loaded data. You can only manually reject loaded files if the 06_Auto_Reject global parameter was set to N when the load scenario was run.

You can alternately set the file rejection process to occur automatically. If you set the 06_Auto_Reject global parameter to Y, then if a failure occurs during the file load, the process automatically rejects the file. However, automatically rejecting a failed file load also clears staging tables, preventing any analysis from being done on those tables.

If grouping is used, and you specify a master bill file for rejection, then ODI automatically performs the following functions on the master and associated group files:

• Validates the files.
• Determines the associated group file names associated with each file.
• Determines whether the data files have been published.
• Performs the reject process for each individual group file depending on the published state.

To reject a file

1. Log in to the Oracle Data Integrator as the repository owner.
2. On the Designer tab, expand Packages, and expand the RejectFile package.
3. Expand Scenarios, right-click on the REJECTFILE scenario, and click Run.
4. Select the ODIAgent from the Logical Agent drop-down list, and click OK.
5. In the Variable Values dialog, uncheck the File_Name variable.
6. In single quotation marks, enter the name of the file to reject. Enter the file name only, not the path.
7. Click OK.