My Oracle Support Banner

There Is No Entry In SA_EXPORT_LOG Table For A Reloaded Store/Day (Doc ID 2177223.1)

Last updated on DECEMBER 01, 2020

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.