Purge Aged Cost Events (cost_event_purge_job)
|
Module Name |
cost_event_purge_job |
|
Description |
Purge Aged Cost Events |
|
Functional Area |
Future Cost |
|
Module Type |
Admin - Ad hoc |
|
Module Technology |
Background Processing |
|
Catalog ID |
N/A |
|
Wrapper Script |
b8dwrap.ksh |
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 event table based on its purge criteria from system parameter settings. The Cost Events History Days parameter will determine cost events that were old/aged from the creation date. These cost event records should exist from Cost Event Configuration table. 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 specific cost event related tables as per Run Event Type. 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.
Key Tables Affected
Table 9-4 Key Tables Affected
| Table | Select | Insert | Update | Delete |
|---|---|---|---|---|
|
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 |
Yes |
No |
No |
|
B8D_COST_EVENT_PURGE_STG |
Yes |
Yes |
No |
Yes |
|
COST_EVENT |
No |
No |
No |
Yes |
|
COST_EVENT_RESULT |
No |
No |
No |
Yes |
|
COST_EVENT_THREAD |
No |
No |
No |
Yes |
|
COST_EVENT_SUPP_COUNTRY |
No |
No |
No |
Yes |
|
COST_EVENT_NIL |
No |
No |
No |
Yes |
|
COST_EVENT_PRIM_PACK |
No |
No |
No |
Yes |
|
COST_EVENT_COST_CHG |
No |
No |
No |
Yes |
|
COST_EVENT_RECLASS |
No |
No |
No |
Yes |
|
COST_EVENT_DEAL |
No |
No |
No |
Yes |
|
COST_EVENT_MERCH_HIER |
No |
No |
No |
Yes |
|
COST_EVENT_ORG_HIER |
No |
No |
No |
Yes |
|
COST_EVENT_COST_ZONE |
No |
No |
No |
Yes |
|
COST_EVENT_ELC |
No |
No |
No |
Yes |
|
COST_EVENT_SUPP_HIER |
No |
No |
No |
Yes |
|
COST_EVENT_ITEM_COST_ZONE |
No |
No |
No |
Yes |
|
COST_EVENT_RUN_TYPE_CONFIG |
Yes |
No |
No |
No |
|
COST_EVENT_DEAL_PASSTHRU |
No |
No |
No |
Yes |
|
COST_EVENT_COST RELATIONSHIP |
No |
No |
No |
Yes |
|
COST_EVENT_COST_TMPL |
No |
No |
No |
Yes |