SA_ERROR Table is Not Getting Purged After Error - DISC_REASON_REQ Has Been Corrected
Last updated on FEBRUARY 12, 2018
Applies to:Oracle Retail Sales Audit - Version 13.2 and later
Information in this document applies to any platform.
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.
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