Purge Aged Transfers (transfer_purge_job)

Module Name	transfer_purge_job
Description	Purge Aged Transfers
Functional Area	Transfers, Allocations and RTVs
Module Type	Admin - Ad hoc
Module Technology	Background Processing
Catalog ID	N/A
Wrapper Script	b8dwrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

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

Thread assignment program will filter eligible records from transfer header table and other associated transfer-related tables based on its purge criteria from system parameter settings. The Transfer History Months parameter will determine what transfer records are ready for purging that are considered closed or deleted in status and comparison of transfer close date with tomorrow's current date. 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 transfer header and other associated transfer 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 13-5 Key Tables Affected

Table	Select	Insert	Update	Delete
PERIOD	Yes	No	No	No
SYSTEM_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_TRANSFER_PURGE_STG	Yes	Yes	No	Yes
TSFHEAD	Yes	No	No	Yes
TSFDETAIL	No	No	No	Yes
ALLOC_HEADER	Yes	No	No	Yes
ALLOC_DETAIL	No	No	No	Yes
ALLOC_CHRG	Yes	No	No	Yes
ALLOC_PURGE_QUEUE	Yes	No	No	No
DOC_PURGE_QUEUE	Yes	No	No	No
SHIPSKU	Yes	No	No	Yes
CARTON	No	No	No	Yes
TSFHEAD_CFA_EXT	No	No	No	Yes
TSFHEAD_L10N_EXT	No	No	No	Yes
TSF_ITEM_COST	No	No	No	Yes
TSF_ITEM_WO_COST	No	No	No	Yes
TSF_PACKING	Yes	No	No	Yes
TSF_PACKING_DETAIL	No	No	No	Yes
TSF_XFORM	Yes	No	No	Yes
TSF_XFORM_DETAIL	No	No	No	Yes
TSF_WO_HEAD	Yes	No	No	Yes
TSF_WO_DETAIL	No	No	No	Yes
TSFDETAIL_CHRG	No	No	No	Yes
ORDCUST	Yes	No	No	Yes
ORDCUST_CUSTOMER_DETAIL	No	No	No	Yes
ORDCUST_DETAIL	No	No	No	Yes
ORDCUST_PUB_INFO	No	No	No	Yes
SHIPITEM_INV_FLOW	No	No	No	Yes
SHIPSKU_PRG_HIST	No	Yes	No	No
ORDCUST_DETAIL_PRG_HIST	No	Yes	No	No
ORDCUST_PRG_HIST	No	Yes	No	No
TSFDETAIL_CHRG_PRG_HIST	No	Yes	No	No
TSF_WO_DETAIL_PRG_HIST	No	Yes	No	No
TSF_WO_HEAD_PRG_HIST	No	Yes	No	No
TSF_XFORM_DETAIL_PRG_HIST	No	Yes	No	No
TSF_XFORM_PRG_HIST	No	Yes	No	No
TSF_PACKING_DETAIL_PRG_HIST	No	Yes	No	No
TSF_PACKING_PRG_HIST	No	Yes	No	No
TSF_ITEM_WO_COST_PRG_HIST	No	Yes	No	No
TSF_ITEM_COST_PRG_HIST	No	Yes	No	No
TSFDETAIL_PRG_HIST	No	Yes	No	No
TSFHEAD_L10N_EXT_PRG_HIST	No	Yes	No	No
TSFHEAD_CFA_EXT_PRG_HIST	No	Yes	No	No
TSFHEAD_PRG_HIST	No	Yes	No	No

Design Assumptions

N/A