Duplicate Primary Key Error in single PS_TXN Table and Sequence Used Acrosss Multiple Applications
(Doc ID 2808468.1)
Last updated on SEPTEMBER 22, 2021
Applies to:Oracle JDeveloper - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
A Production server has around 15 ADF applications deployed, and all of them share a single PS_TXN table and PS_TXN_SEQ sequence.
Despite this set up, from time to time there are duplicate values generated for the PK of the table, which has forced the table data to be cleaned multiple times in a day.
The error seen is
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!