My Oracle Support Banner

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 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!

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