Due to Network Issues on Oracle Point of Service(POS), the Same Transaction is Being Resent to Central Office Which is Failing With Unique Constraint Error
(Doc ID 1588370.1)
Last updated on MAY 28, 2021
Applies to:Oracle Retail Point-of-Service - Version 13.3 to 14.0 [Release 13.3 to 14.0]
Information in this document applies to any platform.
On Oracle Retail Point Of Service (ORPOS), due to network issues, the same transaction is resent to Oracle Retail Central Office(ORCO) which is failing with unique constraint.
After sending the transaction to JMS queue, ID_TLOG_BTCH is not updated due to the network errors and the same transaction is picked again for sending which is causing unique constraint errors at CO.
The below exception appears in the POS logs:
Steps To Recreate:
This issue might occur due to network fluctuations wherein the transaction has been posted to the queue but the column ID_TLOG_BTCH on TR_TRN table is not updated with the appropriate value to mark that the transaction has been posted to ORCO.
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