Transactions Incorrectly Failing With Tran Dup Error
(Doc ID 2757439.1)
Last updated on MARCH 08, 2021
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.
Transactions incorrectly failing with transaction DUP_TRAN(duplicate transaction) error code.
RTLOG(Retail transaction log) file was rejected due to DUP_TRAN error code.
Steps to Recreate:
1. Take note of the values of TDUP(transaction duplicate) file, Vdate, and the contents of the MAX_DAYS_COMPARE_DUPS column.
1.1. TDUP file should have a date falling within vdate and vdate-MAX_DAYS_COMPARE_DUPS and take note of the Tran No(transaction number).
1.2. Vdate example = 1/23/2021 and MAX_DAYS_COMPARE_DUPS = 2.
1.3. TDUP file has Tran No. 3-5 used for business date = 1/23/2021.
2. Run saimptlogi process for an old business_date (e.g. RTLOG for business date 1/06/2021 using tran no 4).
3. Notice that the record using Tran No 4 is rejected.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document