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

Last updated on AUGUST 10, 2014

Applies to:

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

Symptoms

PSFT ER connector 9.1.1.6.0 implemented for HR and OIM 11.1.1.5.8 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#11.1.1.3.0] 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#11.1.1.3.0] [[Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073):
org.eclipse.persistence.exceptions.DatabaseException
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 69
ORA-06512: at "PROD_OIM.RECON_CREATE_EVENTS", line 122
ORA-06512: at line 1

Error Code: 1422
Call:
 BEGIN RECON_CREATE_EVENTS.XL_SP_RECON_CREATE_EVENTS(p_intJobID=>?,
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(DatabaseException.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:797)
at org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.executeStoredProcedure(DatabasePlatform.java:1991)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:593)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)

 

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