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

Purging Unbilled or Prepaid Data Records

Oracle Self-Service E-Billing provides a procedure for purging unbilled and prepaid data records, if necessary. You can purge all unbilled or prepaid data records older than a date that you specify.

You might need to purge any unbilled data records that did not get removed from the Oracle Self-Service E-Billing database by either the EBILL_DATALOAD or REJECT_UNBILLED_FILE process. Unbilled data records can remain if, for some reason, unbilled records never get billed.

It is recommended that you keep not more than three months of prepaid data, as this could result in less efficient reporting analysis on the data.

To purge loaded unbilled or prepaid data records

1. Log into SQL*Plus as the schema owner.
2. Run the EDX_PURGE_UNBILLED_DATA or the EDX_PURGE_PREPAY_DATA procedure as shown in the following example

   set serveroutput on

   declare

   vdate varchar2(30) := to_date('05/01/2013','mm/dd/rrrr');

   vval int;

   begin

   EDX_PURGE_UNBILLED_DATE(vdate ,vval);

   dbms_output.put_line(vval);

   end;

   /

   where:

   • EDX_PURGE_UNBILLED_DATA is the purge process. Use EDX_PURGE_UNBILLED_DATA to purge unbilled data and EDX_PURGE_PREPAY_DATA to purge prepaid data.
   • 05/01/2013 is the older-than date.
3. A return value of -1 indicates possible errors. Check the edx_rpt_etl_log file for more information.