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

Rejecting a Group Bill File

You can use the Reject_Group_Bill_File process to perform one of the following:

• Reject a group bill data file and remove loaded data
• Reject the master DIM file only
• Reject one or more statements

You might want to reject a group bill data file and remove loaded data in the following circumstances:

• You want to remove data from the production tables after the load is published.
• The EBILL_DATALOAD job failed and you want to reject the partial load.
• You ran the EBILL_DATALOAD job using the manual publishing option and want to reject the unpublished load.

NOTE:  If you divided your data load file into multiple files and want to reject the entire master bill file, then see Launch the Control Center from the Tools menu..

To reject a group bill file load using the Reject_Group_Bill_File job

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, REJECT, and REJECT_GROUP_BILL_FILE nodes.
4. Right click the REJECT_GROUP_BILL_FILE node and click Start.
5. Specify or verify the following input parameters, then click OK.

   Parameter	Description
   P_01_FILE_NAME	Enter the full name of the Oracle Self-Service E-Billing data file, for example, EBILLING_B2B-DATA-FILE-20121210.DAT. This can be a group or master DIM file name.
   P_02_STATEMENT_KEY	Enter the statement key, which can be found in the statement fact table. The default value is null. The default value setting is for rejecting a file, and data is removed from the OLAP side only.