Cost Change Purge (cost_change_purge_job)

Module Name	cost_change_purge_job
Description	Purge Aged Cost Changes
Functional Area	Cost Change
Module Type	Admin - Ad hoc
Module Technology	Background Processing
Catalog ID	N/A
Wrapper Script	b8dwrap.ksh

Schedule

Oracle Retail Merchandising Schedule

Design Overview

This background job is composed of two-step processing. It will have a threading assignment and a business logic processing.

Thread assignment program will filter eligible records from cost change header table based on its purge criteria from system parameter settings. The Retention of Rejected Cost Changes parameter will determine the number of days that rejected cost changes are held. The Retention of Extracted Cost Changes parameter will determine the number of days extracted cost changes are held. It also should meet the following criteria:

• The status of the cost change is either Delete or Canceled.

• The status of the cost change is Rejected and the effective date of the cost change has met the requirement for the number of days that rejected cost changes are held.

• The status of the cost change is Extracted and effective date of the cost change has met the requirement for the number of days that extracted cost changes are held.

These records are chunked and Thread ID is assigned for each. They will be stored temporarily in a staging table.

The Business logic program will process all records from the staging table. Using bulk processing, this program will delete the records from cost change header and other related cost change tables. It will free up and clean the staging table afterwards. There is a STOP ON NEXT feature in bulk processing (through a loop) where Administrators can stop this batch with a flip of this indicator.

Restart/Recovery

N/A

Key Tables Affected

Table 8-1 Key Tables Affected

Table	Select	Insert	Update	Delete
PERIOD	Yes	No	No	No
PURGE_CONFIG_OPTIONS	Yes	No	No	No
RMS_BATCH_STATUS	Yes	No	No	No
B8D_PROCESS_CONFIG	Yes	No	No	No
JOB_AUDIT_LOGS	No	Ys	No	No
B8D_COST_CHANGE_PURGE_STG	Yes	Yes	No	Yes
COST_SUSP_SUP_HEAD	Yes	No	No	Yes
COST_SUSP_SUP_DETAIL	Yes	No	No	Yes
COST_SUSP_SUP_DETAIL_LOC	Yes	No	No	Yes

Design Assumptions

N/A