SA_ERROR Table is Not Getting Purged After Error Correction
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.
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
Million Knowledge Articles and hundreds of Community platforms