EIM Column Not Created After 8.1.1.11 Ugprade

(Doc ID 1906151.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Financial Services CRM - Version 8.1.1.11.5 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11.5 [IP2013] version, EIM

When attempting to run EIM import,

the following error occurs.

ERROR
-----------------------

"EIMError EIMErrorSubEvent 0 0000013e53ae04d8:0 2014-06-28 02:38:22 These rows could not be inserted into the destination base table because some
EIMError EIMErrorSubEvent 0 0000013e53ae04d8:0 2014-06-28 02:38:22 of the required columns did not have values. Check that all columns which are
EIMError EIMErrorSubEvent 0 0000013e53ae04d8:0 2014-06-28 02:38:22 required in the base table have values in the interface table.
EIMError EIMErrorSubEvent 0 0000013e53ae04d8:0 2014-06-28 02:38:22
EIMError EIMErrorSubEvent 0 0000013e53ae04d8:0 2014-06-28 02:38:22 This failure caused the rows to be eliminated from further processing for this
EIMError EIMErrorSubEvent 0 0000013e53ae04d8:0 2014-06-28 02:38:22 secondary base table. However, processing of the rows WILL continue for other
EIMError EIMErrorSubEvent 0 0000013e53ae04d8:0 2014-06-28 02:38:22 destination base tables."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use EIM_CONTACT table and populate the data
2. define IFB file.
3. Run EIM job

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, you are not able to finish EIM jobs

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