There Is No Entry In SA_EXPORT_LOG Table For A Reloaded Store/Day

(Doc ID 2177223.1)

Last updated on FEBRUARY 09, 2018

Applies to:

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


If a store/day is deleted and reloaded in ReSA ,batch does not make an entry with status as 'R' in SA_EXPORT_LOG table.

Steps to Reproduce:

  1. Delete an existing store/day in ReSA.An entry is made in SA_EXPORT_LOG table with status as 'R' (Ready).
  2. Run saimptlogtdup_upd and saexprms batch and note that status has changed to 'E' (Extracted) and reversal is posted to RMS.
  3. Note that store/day data_status is 'R' in SA_STORE_DAY table ,however there is no entry in SA_EXPORT_LOG table to export the sales after they are reloaded.




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