Why Is Storeday Not Getting Closed When the Same RTLOG File Is Processed Twice?
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.
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms