PSFT Workforce_Sync Recon Fails With ORA-20100:Error In User Attr Modification
Last updated on JANUARY 07, 2018
Applies to:
Identity Manager Connector - Version 9.1.1.6 and laterInformation 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=>?,
<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