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

Running the ETL Purge Process

Oracle Self-Service E-Billing provides the ETL PURGE process for removing data from the Oracle Self-Service E-Billing databases for a specified number of months.

To run the PURGE 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 following directory:
   • UNIX. ebilling_etl_location/purge/purge_process
   • Windows. ebilling_etl_location\purge\purge_process
4. Click Start to run the job. Specify one of following input parameters:
   • P_MONTH. The month name in MON-YYYY format. The PURGE job will purge all data older than this month.
   • P_MONTHS. The number of months of statements you want to remain in the database.