Active Directory User Target Delete Recon Fails With ORA-12899

(Doc ID 1963107.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

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

Symptoms

When running OIM Active Directory User Target Delete Recon, it fails with the following error in oim server log:

oracle.iam.reconciliation.exception.ReconciliationException: Exception occurred while inserting data into table RA_ADUSERE469E5C8 due to java.sql.SQLException: ORA-12899: value too large for column "DEV_OIM"."RA_ADUSERE469E5C8"."RA_COMMONNAMEED26D7A0" (actual: 69, maximum: 64)

When checking value in UD_ADUSER via Form designer, field length is set to 64 but in this case, "Common Name" is greater > 64 chars

Is it just safe to change value > 64 to meet Active Directory schema max length for the attribute?

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