unable to load data to S_ASSET_CON using EIM (Doc ID 740048.1)

Last updated on OCTOBER 13, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.7.2 [18325] and later
Information in this document applies to any platform.
***Checked for relevance on 19-Aug-2014***

Symptoms

The requirement is to associate contacts to existing assets using EIM and the EIM task is failing with following error:

Error message:

Process [Import Contact_Asset] had all rows on EIM_ASSET for batch 20080918:
Import processing failed for all rows. (severity 3).

Steps:

1. Asset records already exist in the base table

2. Load following columns in EIM_ASSET:

AST_ASSET_NUM
IF_ROW_STAT
IF_ROW_BATCH_NUM
AST_ASSET_NUM
ROW_ID
con_person_uid
con_con_priv_flg
con_con_bu
AST_BU
AST_PROD_BU
CON_RELATIONTYPECD
AST_PROD_NAME
AST_COMPUNDWRNTYFL
ASTCUSTOMIZABLEFLG
AST_PRODUNDWRNTYFL
AST_REFERENCEABLEF
AST_SRLNUMVRFD_FLG
AST_UNDMFGWRNTYFLG

3. Run EIM task using following ifb parameter:

INSERT ROWS = S_ASSET, FALSE
UPDATE ROWS = S_ASSET, FALSE

4. Run EIM task.

It fails with following error:

“All rows specified for importing in this process failed. Either no rows were specified or all rows could not be imported into the base tables. All rows failed to be processed for this interface table. Either the data in the rows is invalid for import or row specifications did not match any existing base table rows for export, delete or merge.”

Business impact:
The association of contact to Asset is essential for assigning assets to contacts.

Behavior pattern: This behavior exists for certain assets/contact combination and works fine for some other indicating that this is a data issue.

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