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 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_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
- Go to the following directory:
- UNIX.
EDX_HOME /bin
- Windows.
EDX_HOME \bin
- Run the following command:
|