ORA-00001: UNIQUE CONSTRAINT (APPLSYS.FND_SOA_REQUEST_UK1)
(Doc ID 2249651.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.4 and laterInformation 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 |