Processing to Allow Re-Upload of Deleted Transactions (saimptlogtdup_upd)
|
Module Name |
saimptlogtdup_upd.pc |
|
Description |
Processing to Allow Re-Upload of Deleted Transactions |
|
Functional Area |
Oracle Retail Sales Audit |
|
Module Type |
Admin |
|
Module Technology |
ProC |
|
Catalog ID |
RSA19 |
|
Wrapper Script |
batch_saimptlogtdup_upd.ksh |
Design Overview
The purpose of this batch module is to fetch all deleted transactions for a store day and modify the tdup<Store><rtlog originating system>.dat file to remove deleted transactions, from the tdup range, in order to facilitate the saimptlog/saimptlogi batch to upload deleted transactions again. The batch will process all the store day with data status in Partially Loaded and Ready For Import and a business date that lies between the vdate minus the sa_syatem_options. day_post_sale and the vdate. The batch will not process a store day, if the tdup<Store><rtlog originating system>.dat file does not exist. The batch is designed to work only if sa_system_options.check_dup_miss_tran is set to Y, otherwise, do nothing and come out with successful completion. Also, the batch will not terminate with an error, if the deleted transaction to be removed from tdup range does not exist in the tdup<Store><rtlog originating system>.dat file.