Administration Guide for Oracle Self-Service E-Billing > Running the ETL Jobs Using Oracle Workflow Manager >

Rejecting an Unbilled or Prepaid Data File

You can manually reject an unbilled or prepaid data file that the EBILL_UBDATALOAD or EBILL_PPDATALOAD process failed to load properly. The REJECT_UNBILLED_FILE and REJECT_PREPAY_FILE processes remove all the data associated with the loaded data file that you specify. You run the data rejection processes in Oracle Workflow Builder.

You can only reject loaded unbilled or prepaid files manually if the IN_11_AUTO_REJECT parameter was set to N when you ran the EBILL_UBDATALOAD or EBILL_PPDATALOAD process.

The can alternately set the unbilled or prepaid file rejection process to occur automatically. If you set the IN_11_AUTO_REJECT 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.

To manually reject a loaded unbilled or prepaid ETL file

1. Log in to the Oracle Workflow Builder Design Center as the repository owner.
2. Launch the Control Center from the Tools menu.
3. Expand the EBILLING_ETL_LOCATION, ETL_PF_MODULE, and REJECT nodes.
4. Right click the process for the type of loaded data file you want to reject:
   • REJECT_UNBILLED_FILE
   • REJECT_PREPAY_FILE
5. Click Start.
6. Specify the name of the file you want to reject.