Trusted Recon Fails In DB Application Table Connector, If User Login Is Not In Attribute Mapping (Doc ID 1385814.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Identity Manager Connector - Version 9.1 and later
Information in this document applies to any platform.
**Checked for Relevance on 07-Jun-2013**

Symptoms

On OIM 11.1.1.5, with DB application table connector 9.1.0.5 (latest version), create generic connector using DB application table connector in trusted recon mode.
Do not map any database table column to OIM User Login field. Let OIM generate user id.
Run trusted reconciliation
The following exception occurs, and users are not created to OIM

[2011-11-08T03:48:00.913-05:00] [oim_server1] [ERROR] [IAM-5010000] [oracle.iam.reconciliation.impl] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 0000JE2HtcmFw000jzwkno1EiET1000002,0] [APP: oim#11.1.1.3.0] Generic Information: {0}[[
oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
ORA-06512: at "ICA2_OIM.OIM_SP_RECONBLKUSERCRUD", line 732
ORA-06512: at "ICA2_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71
ORA-06512: at line 1

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