There Is No Entry In SA_EXPORT_LOG Table For A Reloaded Store/Day
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:
- Delete an existing store/day in ReSA.An entry is made in SA_EXPORT_LOG table with status as 'R' (Ready).
- Run saimptlogtdup_upd and saexprms batch and note that status has changed to 'E' (Extracted) and reversal is posted to RMS.
- 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