My Oracle Support Banner

ORA-01422: Recon Events not Getting Created for PSFT Employee Recon Person and Workforce Sync Messages (Doc ID 1915604.1)

Last updated on MARCH 20, 2018

Applies to:

Identity Manager Connector - Version and later
Identity Manager - Version and later
Information in this document applies to any platform.


PSFT ER connector implemented for HR and OIM integration.
All of a sudden, NO recon events are getting created for Person and Workforce sync messages received from HR PROD.

Log file shows the following error

[2014-06-23T14:30:23.997-04:00] [oim_server1] [NOTIFICATION] [IAM-5012250] [oracle.iam.reconciliation.impl] [tid: [ACTIVE].ExecuteThread: '101' for queue: 'weblogic.kernel.Default (self-tuning)'] [APP: oim#] Oim attribute name is User Login and value is XYZ
[2014-06-23T14:30:23.997-04:00] [oim_server1] [WARNING] [] [org.eclipse.persistence.session.oim] [tid: [ACTIVE].ExecuteThread: '101' for queue: 'weblogic.kernel.Default (self-tuning)'] [APP:
oim#] [[Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073):
Internal Exception: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "PROD_OIM.RECON_CREATE_EVENTS", line 122
ORA-06512: at line 1

Error Code: 1422
p_strProfileName=>?, p_strJobName=>?, p_intBatchSize=>?,
p_strEventStatus=>?, p_strChangeType=>?, p_strEntityType=>?,
p_intResourceObjectKey=>?, p_strLoggedinUserName=>?,
p_intMaxRetryCount=>?, p_strActionPerformed=>?,
p_strKeyField=>?, p_dateActionDate=>?, p_intEventID=>?,
p_intBatchID=>?, p_intPrevBatchID=>?,
p_strBatchCompleteFlag=>?); END;
bind => [-1, Peoplesoft HRMS,
 Non-Scheduled Job, 500, Data Received, CHANGELOG, User, 21, XELSYSADM,
5, Event Created by Recon API, 017092, null, => eventID, =>
batchID, => prevBatchID, => batch_complete_flag]
Query: DataReadQuery()
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(
at org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.executeStoredProcedure(
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(



To view full details, 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 a vibrant support community of peers and Oracle experts.