EIM ERRORS WITH BOUNDED PICKLISTS (Doc ID 963040.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 8.1.1 [21112] and later
Information in this document applies to any platform.
***Checked for relevance on 19-Jan-2015***

Symptoms

Customer is updating S_ASSET table by using EIM_ASSET table. When they try to update S_ASSET.STATUS_CD with the value "RETURNED", they receive the following error:

Process [IMPORT Base Asset] had 1722 rows fail                               
 on EIM_ASSET for batch 800 in step 4, pass 113:                             
  Invalid value for bounded picklist column. (severity 6, rows eliminated)   
                                                                             
Interface table:                                                             
EIM_ASSET (EIM_ASSET)                                                        
---------                                                                    
AST_STATUS_CD (Status Code)                                                  
                                                                             
Base table:                                                                  
S_ASSET (Product Instance)                                                   
-------                                                                      
STATUS_CD (Status Code)                                                      
                                                                             
This column contains a bounded picklist value and the value given does not   
correspond to a value in the list-of-values table for the given picklist type.
You can add values through the UI or through the S_LST_OF_VAL_IF interface   
table.                                                                       
                                                                             
This failure caused the rows to be eliminated from further processing for the
target base table. This failure will prevent these rows from being imported at
all.                                                                         

EIM is successful when they use the value "OTHER".

Both OTHER and RETURNED are in the LOV and the S_LST_OF_VAL table.

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