3 Overview of Purge Entity

This topic provides an overview of Purge Entity.

A new Purge Framework is introduced in Oracle FLEXCUBE Universal Banking, where users can configure the data to be purged. This framework consists of two parts:

• Purge Parameter Configuration
• Purge Execution

The following diagram captures the framework of Purge Parameter Configuration.

Figure 3-1 Purge Parameter Configuration Framework

Description of "Figure 3-1 Purge Parameter Configuration Framework"

Workbench will be used to define the list of entities to be purged. Persistence of Purge Entity Configured is achieved through the RADXML saved by the tool.

Purge Parameters Configuration

The Open Development Tool utility for generating the Purge routines is to be used for the initial purge parameter configuration. The tool generates the packages that will have the purge logic based on the criteria. The tool will be used for the following:

1. Maintaining the list of entities that need to be purged. This includes maintaining the Master-Child relationship between the tables. Each entity will have the following:
   • Parent table
   • Primary key for the parent table and the data types of the key fields.
   • List of child tables.
   • Relation with the parent tables and the data types of the key fields.
2. Maintaining the purge behavior – whether the data must be deleted or archived.
3. Maintaining the mode of purge – whether it is bulk or record level.
4. Maintaining the archive table suffix if the purge behavior is to archive the data.
5. Maintaining the filter criteria to determine what data to purge. These filter criteria are applied on the parent table to identify the data to purge, and based on the setup, corresponding data will also be purged from the child tables.