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

Running the ETL_SUPER_PF_2 (ETL Loader) Job

To load data into Oracle Self-Service E-Billing, you use the ETL loader job, called ETL_SUPER_PF_2. This job appears in Oracle Workflow Builder under the process flow package ETL_SUP.

The ETL_SUPER_PF_2 job loads the ETL data into the OLAP database, then by default, automatically accepts the OLAP load and proceeds to update the OLTP database using the OLTP_LD_2 process.

If you run the ETL_SUPER_PF_2 job using the manual acceptance option, you must run the OLAP_ACCEPT_REJECT and OLTP_LD_2 jobs manually on the data file.

You run the ETL loader job from the Design Center in Oracle Workflow Builder. Oracle Warehouse Builder is a single, comprehensive tool for all aspects of data management. It provides data quality, data auditing, fully integrated relational and dimensional modeling, and full life cycle management of data and metadata.

To run the ETL_SUPER_PF_2 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, ETL_PF_MODULE, and ETL_SUP nodes.
4. Right click the ETL_SUPER_PF_2 node (the ETL Loader job) and click Start.
5. A dialog box might appear stating that the object must be deployed before execution. If this dialog appears, click OK.