EIM ERRORS WITH BOUNDED PICKLISTS
(Doc ID 963040.1)
Last updated on JULY 23, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|