EIM ERRORS WITH BOUNDED PICKLISTS
Last updated on MARCH 02, 2017
Applies to:Siebel Enterprise Integration Manager - Version 8.1.1  and later
Information in this document applies to any platform.
***Checked for relevance on 19-Jan-2015***
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)
AST_STATUS_CD (Status Code)
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
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
EIM is successful when they use the value "OTHER".
Both OTHER and RETURNED are in the LOV and the S_LST_OF_VAL table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms