Why Is Storeday Not Getting Closed When the Same RTLOG File Is Processed Twice? (Doc ID 2151904.1)

Last updated on JUNE 28, 2016

Applies to:

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

Goal

When trying to upload same RTLOG again, the process fails with a duplicate transaction error.  However, the system increments the value of SA_STORE_DAY.FILES_LOADED by 1.  Because of this issue, storeday is not getting closed automatically when the DCLOSE transaction is received with the actual number of files expected to be loaded (SA_TRAN_HEAD.REF_NO1).
 

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