DUP_TRAN Error Occurs After Deleting The Store Day Transaction By SAIMPTLOGTDUP_UPD Job
(Doc ID 2937224.1)
Last updated on MARCH 23, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
On : 19.3 version, Operations & Maintenance
When attempting to deleting the store day transaction by SAIMPTLOGTDUP_UPD job and processing transaction number with same transaction number,
the following error occurs.
ERROR
-----------------------
DUP_TRAN
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created transactions for a store day
2. In UI, Store day audit -> entered the store day details
3. More actions -> Delete store day
4. Transactions are been deleted
5. Ran SAGETREF job
6. Ran SAIMPTLOGTDUP_UPD job
7. Process sale transaction with the transaction number already in store day with status as 'D'
8. Ran SA_CREATE_RTLOG job, rejected with DUP_TRAN error
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |