EIM Import Failed With Error NON_UNIQUE_UKEYS (Doc ID 2122499.1)

Last updated on MARCH 31, 2016

Applies to:

Siebel CRM - Version 8.1 [21039] and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Load one test asset into A_ASSET table through EIM using EIM_ASSET table but import failed with error NON_UNIQUE_UKEYS


EXPECTED BEHAVIOR
-----------------------
Asset record should get loaded successfully in S_ASSET table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configured EIM load IFB file  for S_ASSET
2. Loaded the data on to EIM_ASSET
3. Executed the EIM job
4. EIM job failed with error NON_UNIQUE_UKEYS

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the asset load

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