13 Rebuild a Case in Oracle Argus Mart

During the incremental ETL execution, you may need to re-populate certain cases from the scratch due to DLP data corruption or migration of cases in chunk.

To rebuild the entire information for the selected cases:

1. Specify ENTERPRISE_ID/CASE_ID of such cases in the table ETL_MANUAL_RBLD_CASE_LIST.

2. During the Incremental ETL, these cases will be deleted from Reporting Mart (RM) and Signal Mart (SM) tables, and rebuilt from the scratch.

   Note that the cases that are not part of this table, will be processed only for delta data as before.

3. When a case that is rebuilt has an effective start date earlier than the current value in switches START_DATE_CURRENT_DATA_SUPPORT and START_DATE_LOCKED_REVISION_SUPPORT, these switch values will be over-written with the rebuild case effective start date.

Note:

When the case is rebuilt, any reference data change that is present in the case revisions will be lost.

Note:

Oracle recommends to use this feature cautiously and on need basis only.