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

Retrying the OLTP_LD_2 Job Process

The OLTP_LD_2 process runs automatically as part of the following jobs:

• ETL_SUPER_PF_2. When run with the default automatic acceptance, the ETL loader job completes the acceptance and OLTP load automatically.
• OLAP_ACCEPT_REJECT. When you accept a file manually using the OLAP_ACCEPT_REJECT job, the job runs this process to complete the ETL load by updating the OLTP database. (The ETL loader job, ETL_SUPER_PF_2, ran using manual acceptance in this situation.)

If a failure occurs during the OLTP load in either job, follow these instructions to retry the OLTP_LD_2 job process independently.

To retry the OLTP_LD_2 job

1. Log in to the Oracle Workflow Builder Design Center as the repository owner.
2. Go to the Control Center from the Tools menu.
3. Go to the ebilling_etl_location/OLTP_LD2/OLTP_LD_2 directory.
4. Click Start to run the OLTP_LD_2 job.
5. Specify the following input parameters.

   Parameter	What to Enter or Select
   IN_05_FEEDTYPE	B2B or B2C
   IN_06_REGULAR_LOAD	TRUE or FALSE (Default is TRUE).
   IN_07_FILENAME	The full name of the data file, for example, EBILLING_B2B-DATA-FILE-20110710.DAT
   IN_08_FROM_ADDRESS	Valid email address
   IN_09_TO_ADDRESS	Valid email address
   IN_10_CC_address	Valid email address
   IN_11_SMTP_PORT	Port number (default value is 25)
   IN_12_SMTP_SERVER	SMTP server name