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
|