Purge Scheduled Replenishment Induction Staging Tables (repl_indctn

Purge Scheduled Replenishment Induction Staging Tables (repl_indctn_purge.ksh)

Module Name	repl_indctn_purge.ksh
Description	Purge scheduled replenishment induction staging tables
Functional Area	Inventory Management
Module Type	Admin
Module Technology	Shell Script
Catalog ID	N/A
Wrapper Script	N/A

Oracle Retail Merchandising Batch Schedule

The purpose of this module is to remove old scheduled replenishment records from the staging tables. Records that are candidates for deletion are:

Processes that have successfully been processed or processed with warnings that have been uploaded to Merchandising or downloaded to S9T
Processes in error status where all other related records containing the process ID have been processed successfully
Processes that are past the data retention days (that is, the action date is earlier than the retention date)

Restart ability will be implied, because the records that are selected from the cursor will be deleted before the commit.

N/A