Administration Guide for Oracle Self-Service E-Billing > Configuring Jobs > Billing Job Types >

Configuring a HierarchyCleanUp Job

The HierarchyCleanup job removes closed accounts and unsubscribed services from hierarchies. You normally schedule this job to run after all billing cycles have processed for a given billing period.

It usually takes several runs of the ETL process to update all accounts and services in Oracle Self-Service E-Billing for a new billing period. The additional runs are needed to handle multiple billing sources or multiple billing cycles within one billing source. Therefore, accounts and services that no longer exist in the current billing files are never removed by the ETL process.

The job first finds if the HierarchyCleanUp job has been run for the period and any other period prior to the one that has passed. If any period prior to the selected period has not been run with the clean up job, that period will run behind the scenes. For each period being run, the job checks all accounts and services that have no activities for the given period, and sets the last active period for those objects to the given period.

For any accounts and services that have a gap between last active period and the period being run that exceeds the threshold, all references to those objects are removed from hierarchies. For example, if a customer has a business rule stating that accounts and services must be removed if there are no activities for three consecutive billing periods, the Number of Periods is set to 3. When the gap exceeds that number, any references to these objects are removed from the billing hierarchies as well as all business hierarchies. Each account and service has its own counter.

After the HierarchyCleanUp job runs, qualified accounts and services do not appear in any hierarchies or in any reports starting on the period when the cleanup job is run. Historical data for the accounts and services are available in Oracle Self-Service E-Billing for viewing.

The HierarchyCleanUp job consists of only one task, called HierarchyCleanUp.