EIM ERRORS WITH BOUNDED PICKLISTS
(Doc ID 963040.1)
Last updated on APRIL 18, 2023
Applies to:
Siebel Enterprise Integration Manager - Version 8.1.1 [21112] and laterInformation in this document applies to any platform.
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
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
| Symptoms |
| Cause |
| Solution |