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

Configuring a HierarchyPurge Job

When a user deletes a hierarchy, the hierarchy is marked as deleted, but the records of the hierarchy are still in the database. You can schedule the HierarchyPurge job to run periodically (every day, every week, and so on) to remove records marked as deleted from database.

OLTP removes the following data:

• All services and accounts and their subordinated objects, such as service charges and service plans, that are marked as deleted.
• All hierarchies that are marked as deleted.
• All hierarchies that have expired for a specified number of periods. When set a hierarchy to Expire a hierarchy, the data remains in the database until a predefined number of periods pass.

OLAP removes the following data:

• Records of a deleted hierarchy in all related link target workspace tables.
• In all link target workspace tables, records of hierarchy that have expired for a certain number of periods (the threshold value).
• Records for the previously mentioned deleted or expired hierarchies.

Parameters for Configuring the HierarchyPurge Task

Table 15 describes the configuration parameters for the HierarchyPurge task.