Rtlog Files Not Loading Correctly Using Max_days_compare_dups (Doc ID 470248.1)

Last updated on AUGUST 17, 2016

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


Symptoms

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

Cause

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