Administration Guide for Oracle Self-Service E-Billing > Administering the Database >

Purging Statement and Invoice Fact Data

You can purge statement and invoice fact data for:

• A specific company ID
• A specific company ID and period
• A specific account number
• A specific account number and period
• All Consumer Edition (B2C) users
• All Consumer Edition (B2C) users for a specific period

Purging statements and invoices removes data from the following OLAP tables:

• EDX_RPT_STATEMENT_FACT
• EDX_RPT_STATEMENT_PAYMENT_FACT
• EDX_RPT_STATEMENT_ADJUST_FACT
• EDX_RPT_ACCOUNT_FACT
• EDX_RPT_ACCOUNT_CHARGE_FACT
• EDX_RPT_SERVICE_FACT
• EDX_RPT_SERVICE_CHARGE_FACT
• EDX_RPT_SERVICE_PRODUCT_FACT
• EDX_RPT_SERVICE_USAGE_FACT
• EDX_RPT_SERVICE_TARIFF_FACT
• EDX_RPT_SERVICE_DETAIL_FACT
• EDX_RPT_TOP_100_EXPENSIVE_CALL
• EDX_RPT_ACCOUNT_DEST_SUMM
• EDX_RPT_TOP_100_CALLED_NUM
• EDX_RPT_TOP_100_LONG_CALL

When purging by specific account number, the following tables purge only if the statement has only one account:

• EDX_RPT_STATEMENT_FACT
• EDX_RPT_STATEMENT_PAYMENT_FACT
• EDX_RPT_STATEMENT_ADJUST_FACT

To purge statement and invoice fact data

• Run the following command from the EDX_HOME/bin directory (the EDX_HOME\bin directory on Windows):

  UNIX:

  ./purge_data.sh -connstr OLAP schema username/OLAP schema password@OLAP TNS name Input

  Windows:

  purge_data.bat -connstr OLAP schema username/OLAP schema password@OLAP TNS name Input

  where Input is one of the following:

  • Fact data by specific company ID: -statement fact -company "Company ID"
  • Fact data by specific company ID and period: -statement fact -company "Company ID" -period Start period Mon-YYYY End period Mon-YYYY
  • Fact data by specific account number: -statement fact -account Account number
  • Fact data by specific account number and period: -statement fact -account Account number -period Start period Mon-YYYY End period Mon-YYYY
  • All B2C fact data: -statement fact -b2c
  • All B2C Fact data for a specific period: -statement fact -b2c -period Start period Mon-YYYY End period Mon-YYYY