My Oracle Support Banner

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<prefix>_SOAINFRA.AD_PK) violated (Doc ID 1955591.1)

Last updated on MARCH 04, 2024

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

Not able to open audit flow for some instances, where seeing errors related to AUDIT DETAILS table in the dehydration store.

 

ERROR
-----------------------

 

 

Changes

Applied patch 13904546 which theoretically resolves an  unique constraint violated against the primary key of the AUDIT_TRAIL table; but the error is against the AUDIT_DETAILS table.
This error occurs when the audit set to ASYC.  If set the audit to SYNC there does not experience the aberrant behavior.  

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
Changes
Cause
Solution
References


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