Why SA_STORE_DAY.DATA_STATUS Column Updated to P After Running Saimptlogfin, If Saimptlogi Batch Aborts With "INVLD_RTLOG_ORIG_SYS" Error Even When No Data Was Imported? (Doc ID 2214413.1)

Last updated on DECEMBER 18, 2016

Applies to:

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

Goal

Why SA_STORE_DAY.DATA_STATUS column updated to P after running Saimptlogfin batch and FILES_LOADED updated to '0' , if Saimptlogi batch aborts with "INVLD_RTLOG_ORIG_SYS" error even when no data was imported?

Note: But if batch aborts with "POSUNEXPECTEDSTOREDAY" error then DATA_STATUS,FILES_LOADED are not updated. It remains as DATA_STATUS='R' and FILES_LOADED=NULL.
 

Solution

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