Purge PO Induction Staging Tables (po_indctn_purge.ksh)
|
Module Name |
po_indctn_purge.ksh |
|
Description |
Purge PO induction staging tables |
|
Functional Area |
Purchase Orders |
|
Module Type |
Admin |
|
Module Technology |
Shell Script |
|
Catalog ID |
RMS499 |
|
Wrapper Script |
rmswrap_shell.ksh |
Design Overview
The purpose of this module is to remove old purchase order 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 that have status = 'PE' processed with errors and have no liked data
-
Processes in error status where all other related records containing the process ID have been processed successfully
-
Processes that are passed the data retention days (system_options.proc_data_retention_days)
-
All order records within a process where all related records for the order in the other staging tables are successfully uploaded to Merchandising. The process tracker record should not be deleted if there are other orders that are not uploaded to Merchandising.