My Oracle Support Banner

SVC_POSUPLD_STATUS Table Is Not Getting Purged (Doc ID 2193039.1)

Last updated on AUGUST 10, 2020

Applies to:

Oracle Retail Sales Audit - Version 15.0 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.


The SVC_POSUPLD_STATUS table is not purged as part of the salesuploadarch.ksh batch job. This job is purging the SVC_POSUPLD_LOAD table, but not the SVC_POSUPLD_STATUS table.


Steps to Reproduce:

1. Load POSU files older than 14 days using salesupload and salesprocess jobs.
2. Run salesuploadarch.ksh.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.