My Oracle Support Banner

SA_ERROR Table is Not Getting Purged After Error - DISC_REASON_REQ has Been Corrected (Doc ID 2290262.1)

Last updated on APRIL 02, 2018

Applies to:

Oracle Retail Sales Audit - Version 13.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

To view full details, 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 a vibrant support community of peers and Oracle experts.