SVC_POSUPLD_LOAD_ARCH Table Is Not Purged For All Records Per Defined Retention (Doc ID 2230700.1)

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.

Symptoms

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 :

  1. Ensure there is data older than Vdate-1 present in SVC_POSUPLD_REJ_RECS and SVC_POSUPLD_LOAD_ARCH tables.
  2. Run salesuploadpurge batch with retention period as 1.
  3. Note that any data older than Vdate-1 is deleted from SVC_POSUPLD_REJ_RECS table.
  4. 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.

Changes

 

Cause

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