Purge FILE_UPLOAD_STATUS and FILE_UPLOAD_ERRORS Tables (file_upload_errors_purge.ksh)
|
Module Name |
file_upload_errors_purge.ksh |
|
Description |
Purge FILE_UPLOAD_STATUS and FILE_UPLOAD_ERRORS Tables. |
|
Functional Area |
Administration |
|
Module Type |
Admin |
|
Module Technology |
Ksh |
|
Catalog ID |
N/A |
|
Wrapper Script |
rmswrap_shell.ksh |
Design Overview
The purpose of this program is to purge FILE_UPLOAD_STATUS and FILE_UPLOAD_ERRORS tables regularly in Merchandising.
To validate the status of sales file upload process in Merchandising, the error handling in sales upload process has been enhanced to capture the following attributes of file upload status in FILE_UPLOAD_STATUS and FILE_UPLOAD_ERRORS tables.
-
Filename
-
Status
-
# of lines in file
-
# of Records uploaded
-
# of Records failed processing
-
Date/Time process started
-
Date/Time processing completes
-
Location (store or warehouse where file originated). For stock counts this would be the physical warehouse.
If errors are identified, the error message, line text and line ID are captured in the FILE_UPLOAD_ERRORS table. The FILE_UPLOAD_STATUS and FILE_UPLOAD_ERRORS tables are replicated thru golden gate, so that customer can verify the upload file results through DAS views.
The file_upload_errors_purge.ksh script is scheduled to run as part of the nightly batch, to purge FILE_UPLOAD_STATUS and FILE_UPLOAD_ERRORS tables regularly in Merchandising based on the retention days input parameter.