How to import data to a LOV Type column?

When importing data from _XMIF or some other Interface table users might encounter the following error message in the trace file:

[ERR00] Interface table: [ERR00] S_XXXX_XMIF (Interface for XXXX Built-In M: 1 Extension Table) [ERR00] -------------- [ERR00] [ERR00] Base table: [ERR00] S_XXXX_XM (Account M: 1 Extension) [ERR00] ------------ [ERR00] TYPE (Type) [ERR00] This column contains a bounded picklist value and the value given does not [ERR00] correspond to a value in the list-of-values table for the given picklist type.

Siebel Version 7 log file message (example):

Process [Import Account 1] had 1 row fail
on EIM_ORG_EXT_XM for batch 100 in step 4, pass 104:
Invalid value for bounded picklist column. (severity 6, row eliminated)

Interface table:
EIM_ORG_EXT_XM (EIM_ORG_EXT_XM)
--------------
TYPE (Type)

Base table:
S_ORG_EXT_XM (Account M:1 Extension)
------------
TYPE (Type)

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.

This error message indicates that either a picklist has not been created for this column (TYPE) or the value in the IF table for this column (TYPE) does not correspond to one of the values in the picklist for this column. To resolve this, make sure that:

 

a. A picklist already exists for this column
 

b. The value being imported for this column corresponds to one of the values in the picklist.

For example: Assume that the import is into the S_ORG_EXT_XM table. Do the following:

 

1. Find LOV type for S_ORG_EXT_XM

Go into Siebel Tools, select 'Types' tab, click on 'Table'

Create a query to find S_ORG_EXT_XM table

With S_ORG_EXT_XM table selected, expand the 'Table' tree control in the Object Explorer and select the 'Column' tree control. Find the 'Type' column by selecting 'T' on the alpha bar.

With 'Type' column highlighted, find the following two attributes in the Properties window:
Lov Bounded: TRUE Lov Type: ORG_EXT_XM_TYPE

 

2. Find ORG_EXT_XM_TYPE via GUI

Go into the Siebel application and access all available screens, by using the Site Map (View > Site Map). The Site Map provides hyperlinks to all screens and views

Select the Application Administration screen hyperlink

Select the List of Values view hyperlink

Query on the 'Display Value' column for ORG_EXT_XM_TYPE to make sure that the picklist already exists

 

3. Add values for this bounded picklist

 

Add picklist values via Graphical User Interface (GUI):

1. In the Siebel application navigate to the List of Values view and create a new record.

Note: To navigate to the List of Values view please select Screens > Application Administration > List of Values in Siebel versions 5 and 6. In Siebel 7 use the Site Map as described above.

2. In 'Type' column, type ORG_EXT_XM_TYPE.

3. In 'Display value' column, insert any value to use for this type. (A Language Name will need to be specified in the GUI for version 6.0 and version 7.)

4. Repeat step 3 until records are created for all values to have in this picklist

Add picklist values via Enterprise Integration Manager (EIM):

1. Populate S_LST_OF_VAL_IF table, set TYPE column to 'ORG_EXT_XM_TYPE', set VAL column to any value to use for this type. Make sure to populate all the required fields in S_LST_OF_VAL_IF table. (EIM_LST_OF_VAL is the interface table that is recommended to use for version 6.0 and version 7, where LOV_TYPE and LOV_VAL are the equivalent columns.).

2. Repeat step 1 until all records are inserted into IF table for all values to have in this picklist.

3. Import data from S_LST_OF_VAL_IF (or EIM_LST_OF_VAL for version 6.0 and version 7) to S_LST_OF_VAL via EIM.

After new values are added, use these values to populate TYPE column in S_ORG_EXT_XMIF table. Please note that when importing data via User Interface, Siebel Client will check the PickList property for each field in a certain business component. When using EIM to import data into base columns, EIM will check the LOV Type property defined for each column in a base table. It is possible to insert data into a particular column via GUI but not via EIM since they are looking at different properties.

Tags