My Oracle Support Banner

PSFT Workforce_Sync Recon Fails With ORA-20100:Error In User Attr Modification (Doc ID 1352056.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

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

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=...
intUserKey_in=..>
<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

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.