EBS Responsibilities Provisioning Fails with ORA-01000: maximum open cursors exceeded
(Doc ID 3057319.1)
Last updated on NOVEMBER 06, 2024
Applies to:
Identity Manager Connector - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
Provisioning of EBS Responsibilities fails.
When checking the 'Resource History' in OIG, we could see the 'Add Responsibility' task in 'Rejected' status.
The OIM logs show error
org.identityconnectors.framework.common.exceptions.ConnectorException: Error occurred while adding the child data :Error occurred while adding the child data :ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
and the exception is {1} and the exception is {1}
at org.identityconnectors.ebs.EBSConnector.addAttributeValues(EBSConnector.java:348)
at org.identityconnectors.framework.impl.api.local.operations.UpdateImpl.addAttributeValues(UpdateImpl.java:118)
......................
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 |