SVC_POSUPLD_LOAD_ARCH Table Is Not Purged For All Records Per Defined Retention
(Doc ID 2230700.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle Retail Merchandising System - Version 14.0 to 14.0.4 [Release 14.0]
Information in this document applies to any platform.
SALESUPLOADPURGE.ksh (Purge Aged Archived POSU Transactions) batch does not purge all records from SVC_POSUPLD_LOAD_ARCH table per defined retention period. It ignores one day of data in this table.
Steps to Reproduce :
- Ensure there is data older than Vdate-1 present in SVC_POSUPLD_REJ_RECS and SVC_POSUPLD_LOAD_ARCH tables.
- Run salesuploadpurge batch with retention period as 1.
- Note that any data older than Vdate-1 is deleted from SVC_POSUPLD_REJ_RECS table.
- Note that any data older than Vdate-2 is deleted from SVC_POSUPLD_LOAD_ARCH table.
Due to this,data is not consistent across both tables.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document