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

Running the Reject_Group_Bill_File Job

You can use the Reject_Group_Bill_File job to manually reject a group bill data file and remove loaded data, reject the Master DIM file only, or to reject one or more statements.

Use the Reject_Group_Bill_File job to manually reject a group bill data file and remove loaded data in the following circumstances:

• You want to remove data from the production tables (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, see Running the Reject_Master_Bill_File Job.

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.

   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_REJECT	Indicate whether to reject the file: Y rejects the file (Default).
   P_03_PUBLISHED	Indicate whether the data has been published: Y - Yes (Default) or N - No.
   P_04_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.)