Administration Guide for Oracle Billing Insight > Loading Billing Data Into Oracle Billing Insight >

Purging Loaded Data

Oracle Billing Insight provides an ODI process for removing data from the Oracle Billing Insight database for a specified number of months.

You might need to remove data that has become stale or want to maintain a specific number of periods in your database.

To run the data purge process

1. Log in to the Oracle Data Integrator as the repository owner.
2. On the Designer tab, expand Packages, and expand the PurgeData package.
3. Expand Scenarios, right-click on the PURGEDATA scenario, and click Run.
4. Select the ODIAgent from the Logical Agent drop-down list, and click OK.
5. In the Variable Values dialog, uncheck the MonthstoKeep global variable, and enter the number of months of billing data that you want to keep in the Value field.
6. Click OK.