PSFT Workforce_Sync Recon Fails With ORA-20100:Error In User Attr Modification

(Doc ID 1352056.1)

Last updated on JANUARY 10, 2016

Applies to:

Identity Manager Connector - Version 9.1.1.6 and later
Information in this document applies to any platform.
**Checked for relevance on 31-Jul-2014**

Symptoms

Using PSFT ER Connector Version 9.1.1.6, a Person_Basic_Sync incremental reconciliation works fine, but Workforce_sync fails, and the Job details do not get updated in OIM. The following exception is seen in the log:

<Error> <oracle.iam.reconciliation.dao>
 <IAM-5010001> <Calling stored procedure - XL_SP_RECONEVALUATEUSER
 strTargetTableName_in=RA_PEOPLESOFTHRMS41
 strRequiredAttributesList_in=RECON_USR_LOGIN
 strMatchingRule_in=(((UPPER(USR.USR_LOGIN)=UPPER(RA_PEOPLESOFTHRMS41.RECON_USR_LOGIN))))
 intEventKey_in=18204
 intUserKey_in=1>
 <Jun 13, 2011 3:09:58 PM EDT> <Warning>
 <org.eclipse.persistence.session.oim> <BEA-000000> <
Exception [EclipseLink-4002] (Eclipse Persistence Services  2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-20100: Error in User Attribute Modification
ORA-06512: at "DEV_OIM.OIM_USER_MGMT", line 753
ORA-06512: at line 1

Error Code: 20100
 Call: BEGIN OIM_USER_MGMT.BulkUserModify(p_intUserKey=>?, p_arUSRList=>?,
p_arColumnlist=>?, p_arColumnValue=>?, p_arMLSColLocaleValue=>?,



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