ORA-00001: UNIQUE CONSTRAINT (APPLSYS.FND_SOA_REQUEST_UK1) (Doc ID 2249651.1)

Last updated on MARCH 30, 2017

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version,


When audit level for soa-infra is set to OFF, ISG is no longer working and below error is seen in SOA Suite log:


Error Details

[2015-09-15T20:16:00.516+08:00] [soa_server1] [ERROR] []
[oracle.soa.mediator] [tid: [ACTIVE].ExecuteThread: '10' for queue:
'weblogic.kernel.Default (self-tuning)'] [userId: CPWEB] [ecid:
296f3baf141868bf:-444adf24:14fc77328a8:-8000-00000000000b964d,0] [APP:
soa-infra] [J2EE_APP.name: soa-infra] [J2EE_MODULE.name: fabric]
[WEBSERVICE.name: CUX_AR_CUST_IMPWS_PKG_Service] [WEBSERVICE_PORT.name:
CUX_AR_CUST_IMPWS_PKG_Port] [component_instance_id: 9189777] [composite_name:
PROD1_PLSQL_CUX_AR_CUST_IMPWS_PKG!1.0] [component_name:
CUX_AR_CUST_IMPWS_PKG_BPEL]
oracle.apps.fnd.isg.monitor.callout.SOAPAuditUtil.createRequest ORA-00001:
unique constraint (APPLSYS.FND_SOA_REQUEST_UK1) violated[[

 

...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Login:EM ->SOA infrastructure Home->Common Properties

Disable the audit

It errors with : ORA-00001: unique constraint (APPLSYS.FND_SOA_REQUEST_UK1) violated in the

Once the audit is enabled there are no errors noticed.

 

Note : In either cases with or without audit enabled the response returned is fine, but the soa log shows the unique constraint error in case the audit is disabled.



WORKAROUND
------------------------

Set audit level for soa-infra to ON.

However this workaround is not satisfying as it severely affects performance



Cause

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 hundreds of Community platforms