Administration Guide for Oracle Billing Insight > 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 users
• All Consumer Edition users for a specific period

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

• EDX_RPT_STATEMENT_FACT
• EDX_RPT_STATEMENT_CONTENT
• EDX_RPT_STATEMENT_PAYMENT_FACT
• EDX_RPT_STATEMENT_ADJUST_FACT
• EDX_RPT_CONSUM_FACT
• EDX_RPT_SERVICE_MISC_FACT
• EDX_RPT_ACCOUNT_FACT
• EDX_RPT_ACCOUNT_CHARGE_FACT
• EDX_RPT_PREPAY_ACCOUNT_FACT (Consumer Edition only)
• EDX_RPT_PREPAY_PRODUCT_FACT (Consumer Edition only)
• EDX_RPT_PREPAY_DETAIL_FACT (Consumer Edition only)
• 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_TOP_100_LONG_CALL
• EDX_RPT_AVG_BILLED_SUMM (Consumer Edition only)

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

1. Go to the following directory:
   • UNIX. EDX_HOME/bin
   • Windows. EDX_HOME\bin
2. Run the following command:
   • UNIX. ./purge_data.sh -connstr OLAP schema user_name/OLAP schema password@EBILL TNS name Input
   • Windows. purge_data.bat -connstr OLAP schema user_name/OLAP schema password@EBILL 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