SVC_POSUPLD_LOAD_ARCH Table Is Not Purged For All Records Per Defined Retention
Last updated on FEBRUARY 13, 2017
Applies to:Oracle Retail Merchandising System - Version 14.0.1 and later
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms