Rtlog Files Not Loading Correctly Using Max_days_compare_dups
Last updated on FEBRUARY 05, 2018
Applies to:Oracle Retail Sales Audit - Version 12.0.7 and later
Information in this document applies to any platform.
Checked for relevance :28 Jun 2011
In Oracle Retail Merchandising System (RMS) Version: 12.0.5, By processing RTLOG files of two consecutive days, the transactions from the second day that has transaction numbers that were consecutive with the transaction numbers from the first day were kicked out as duplicate transactions and added to the tdup file. None of the transaction numbers were actually duplicates.
Steps To Reproduce:
1- Process the first day's RTLOG file.
2- Process the second day's RTLOG file.
3- Observe that transactions that are consecutive with the tran numbers from day one have been rejected for the second day with the following errors:
DUP_TRAN, THEAD_IN_ILLEGAL_POS, FTAIL_IN_TRAN in error file
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