My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

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

[soa_server1] [ERROR] []
[oracle.soa.mediator] [tid: [ACTIVE].ExecuteThread: '10' for queue:
'weblogic.kernel.Default (self-tuning)'] [userId: <USER_ID>] [ecid:
<ecid>,0] [APP:soa-infra] [J2EE_APP.name: soa-infra] [J2EE_MODULE.name: <module_name>]
[WEBSERVICE.name: CUX_AR_CUST_IMPWS_PKG_Service] [WEBSERVICE_PORT.name:
CUX_AR_CUST_IMPWS_PKG_Port] [component_instance_id: <instance_id>] [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



Changes

 

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.