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

Running the OLAP_ACCEPT_REJECT Job

By default, the ETL_SUPER_PF_2 job uses the automatic acceptance option, which automatically accepts the OLAP load and updates the OLTP database. The OLAP_ACCEPT_REJECT job is available to run in the following situations:

• To manually accept the file. If you ran the ETL_SUPER_PF_2 job using the manual acceptance option (ran ETL_SUPER_PF_2 job with the IN_05_OLTP_FLAG parameter set to M), then you must complete the load process by running the OLAP_ACCEPT_REJECT job to accept the file, which initiates the OLTP_LD_2 job process to update the OLTP database and the post-ETL process to perform split billing task.
• To manually reject the file. If the ETL_SUPER_PF_2 job fails, run the OLAP_ACCEPT_REJECT job to reject the file and remove the data that was partially loaded into the OLAP database.

To manually accept or reject the ETL load using the OLAP_ACCEPT_REJECT 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. Go to the EBILLING_ETL_LOCATION/ACPT_REJ/OLAP_ACCEPT_REJECT directory.
4. Click Start to run the job.
5. Specify or verify the following input parameters.

   Parameter	What to Enter or Select
   P_FILE_NAME	Enter the full name of Oracle Self-Service E-Billing data file, for example, EBILLING_B2B-DATA-FILE-20111210.DAT
   P_02_ACCEPT_REJECT	To accept the file, type Y; to reject the file, type N. The default value is N.
   P_03_OLAP_FLAG	Verify that the value is 1, to require a manual acceptance for the OLTP update. (If the value is 0, the ETL load was run using the default setting to automatically accept the file.)
   P_04_OLTP_FLAG	Verify that the value is M, to require manual acceptance for the OLTP update. (If the value is null, the ETL load was run using default setting to automatically accept the file.)
   P_05_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.)

   If you manually accept the file, the OLAP_ACCEPT_REJECT job completes the ETL load process by initiating the OLTP_LD_2 process, which reads data from the exchange table (EDX_RPT_ETL_XCHANGE) in the OLTP database to build accounts, service, and hierarchy tables in the OLTP database by invoking the following sub loaders.

   Subloader	Description
   Period loader	Inserts rows into the edx_omf_period table.
   Account loader	Inserts rows into the edx_bsl_amf_baccount table (using select distinct account ID's).
   Service loader	Inserts rows into the edx_omf_serviceagreement table.
   OMF loader	Not applicable.
   Company loader	Inserts rows into the company table, edx_bsl_cmf_company (selects distinct company ID's).
   Hierarchy loader	The hierarchy loader performs the following tasks in both the OLAP and OLTP databases: Reads data from the exchange table in the OLTP database and synchronizes hierarchy tables. Creates hierarchies for companies in the company table that do not have hierarchies. Puts any new accounts under these companies in their hierarchies. Puts any new service agreements under these accounts in their hierarchies.

   If you manually reject the ETL load file, the OLAP_ACCEPT_REJECT job removes the data from the OLAP database.