My Oracle Support Banner

SOA Purge Job Failing for table SCA_FLOW_ASSOC with ORA-02292: integrity constraint (SOAPRD_SOAINFRA.FA_CORR_FLOW_INSTANCE_FK) violated - child record found (Doc ID 2995814.1)

Last updated on OCTOBER 09, 2024

Applies to:

Oracle SOA Suite - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Soa purge job is throwing below error
------------------------
ORA-20001: Exception while purging SOA Instances
ORA-06512: at "WAPOL_FRAMEWORK.SOA_PURGING", line 211
ORA-02292: integrity constraint (SOAPRD_SOAINFRA.FA_CORR_FLOW_INSTANCE_FK) violated - child record found
ORA-06512: at "SOAPRD_SOAINFRA.SOA", line 808
ORA-06512: at "SOAPRD_SOAINFRA.SOA", line 251
ORA-06512: at "SOAPRD_SOAINFRA.SOA_FABRIC", line 294
ORA-06512: at "SOAPRD_SOAINFRA.SOA_FABRIC", line 280
ORA-06512: at "SOAPRD_SOAINFRA.SOA_FABRIC", line 273
ORA-06512: at "SOAPRD_SOAINFRA.SOA_FABRIC", line 289
ORA-06512: at "SOAPRD_SOAINFRA.SOA", line 240
ORA-06512: at "SOAPRD_SOAINFRA.SOA", line 753
ORA-06512: at "SOAPRD_SOAINFRA.SOA", line 3355
ORA-06512: at "WAPOL_FRAMEWORK.SOA_PURGING", line 157
ORA-06512: at "WAPOL_FRAMEWORK.SOA_PURGING", line 157
ORA-06512: at line 1

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


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