|
Administration Guide for Oracle Self-Service E-Billing > Running the ETL Jobs Using Oracle Workflow Manager >
Running the LOAD_PRODUCTION Process Manually
The LOAD_PRODUCTION process runs automatically as part of the EBILL_DATALOAD. However, if you run the EBILL_DATALOAD job with the IN_05_PUBLISH parameter set to M for the manual publish option, then you must manually run the LOAD_PRODUCTION job to complete the ETL process and update the OLTP database. CAUTION: If you are running a catch-up load, then you must load past bill files sequentially and check log files to verify that each load is successful before proceeding to the next period. Also check that multiple files in the same billing period have loaded successfully. If a bill file does not load successfully, then that billing period data might not appear on analytic reports because the Hierarchy Node table might not load correctly.
The LOAD_PRODUCTION job moves the data into the OLAP production tables and 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 subloaders as described in Table 75.
Table 75. Subloader Actions
|
|
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, selecting distinct company ID's. |
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.
|
To run the LOAD_PRODUCTION process
- Log in to the Oracle Workflow Builder Design Center as the repository owner.
- Go to the Control Center from the Tools menu.
- Expand the EBILLING_ETL_LOCATION, PROD_LD, and LOAD_PRODUCTION nodes.
- Right click the LOAD_PRODUCTION node and click Start.
- Specify the following input parameters.
|
|
IN_06_REGULAR_LOAD |
Specify whether the ETL-Bill file load is for the regular, or current, billing period. If the load is for the regular billing period, then specify True. The default is True. If this is a catch-up load for a past billing period, then specify False. Catch-up loads are used in the Business Edition of Oracle Self-Service E-Billing only. |
IN_07_FILENAME |
The full name of the data file, for example, EBILLING_B2B-DATA-FILE-20110710.DAT |
IN_08_FROM_ADDRESS |
The email address of the address to appear in the from field on email notifications sent by the job. |
IN_09_TO_ADDRESS |
The email address to send any notifications sent by the job, such as admin@example.com. |
IN_10_CC_address |
An email address to copy on any notifications sent by the job, such as admin2@example.com. |
IN_11_SMTP_PORT |
Port number. The default value is 25. |
IN_12_SMTP_SERVER |
The name of the SMTP server to use for sending email notifications. |
|
