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
- Log in to the Oracle Workflow Builder Design Center as the repository owner.
- Launch the Control Center from the Tools menu.
- Go to the
EBILLING_ETL_LOCATION/ACPT_REJ/OLAP_ACCEPT_REJECT directory.
- Click Start to run the job.
- Specify or verify the following input parameters.
|
|
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.
|
|
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.
|