Some Transactions Are Not Exported to RMS After HQ Manager Overrides the Error

(Doc ID 1426035.1)

Last updated on MAY 03, 2017

Applies to:

Oracle Retail Sales Audit - Version 12.0.5IN to 12.0.10.3IN [Release 12.0]
Information in this document applies to any platform.

Symptoms

Transactions are not exporting to Oracle Retail Merchandising System (RMS) after Head Quarters (HQ ) manager overrides the errors one or more days after setting the data status to Fully loaded.

Steps to Reproduce:

  1. Export RESA Transaction Log (RTLOG) into Retail Sales Audit (RESA) such that some transactions have errors such as "RECORDS_REJECTED","MISSING_TRAN_BIG_GAP", where in sa_error a tran_seq_no is attached to it.
  2. Audit transactions without errors and execute Saexprms and Prepost saexprms post.
  3. Notice one more record is inserted in SA_EXPORT_LOG with status R for the STORE_DAY_SEQ_NO.
  4. Log in as a Store Manager and overide the error and close the store as there is no other way to resolve the error.
  5. Notice the data status is set to 'F' (Fully loaded) and Audit status is set to 'H' (HQ Errors Pending).
  6. Execute Saexprms.
  7. Notice the record in SA_EXPORT_LOG with status R for the STORE_DAY_SEQ_NO is set to Status E.
  8. Execute saexprms post.
  9. Notice there is nor record inserted in SA_EXPORT_LOG for the STORE_DAY_SEQ_NO in step 7.
  10. Log in an HQ Manager and over ride the errors for the for the STORE_DAY_SEQ_NO in step 7.
  11. Notice the Audit status is set to A (audited).
  12. Notice there is no record in SA_EXPORT_LOG for the STORE_DAY_SEQ_NO in step 7 with status 'R' and hence the transaction will not be exported to RMS.



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