NumberFormatException: Users Not Syncing From EBS To OIM Due To Postal Code (Doc ID 2246109.1)

Last updated on MARCH 26, 2017

Applies to:

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

Symptoms

Reconciliation event is not created, If the post code is alphanumeric like "J3B 8M8" in EBS target, On reconciliation following exception in logs

java.lang.NumberFormatException
oracle.iam.connectors.icfcommon.service.oim11.OIM11Reconciliation :processReconciliationResult : Reconciliation event create failed for [{Person

Changes

 In OIM, the datatype of RA_EBS_ADRS and UD_EBS_ADRS needs to be changed to varchar.

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