My Oracle Support Banner

Transactions Incorrectly Failing With Tran Dup Error (Doc ID 2757439.1)

Last updated on AUGUST 19, 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.