SA_ERROR Table is Not Getting Purged After Error Correction

(Doc ID 2290262.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms


SA_ERROR table is not getting purged after error correction for discounts.

Steps To Recreate:
1. Process the RTLOG file which contains In-store discount but discount_type is null.
2. After processing the RTLOG file sa_error is recorded with error: DISC_REASON_REQ.
3. Now log into application and try to resolve the error by following below steps:

a. In RTLOG file Instore discount is defined for the item1. Now select Promotion and give all the required fields. Remark against that record will be erased. But Error on "sales audit errors" screen will not be removed.
b. In RTLOG file Instore discount is defined for the item2. Now select employee discount and give all the required fields. Remark against that record will be erased. Error on "sales audit errors" screen will also be removed.

4. Due to the errors not being deleted from sa_error table its not posting to tran_data.
 

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