EIM Param USE MLOV LIC = TRUE (Doc ID 509711.1)

Last updated on AUGUST 08, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.2.5 SIA [19227] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2.5 [19227] Hi Tech
Database: Oracle 10.2.0.2
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Red Hat Linux 4.0

This document was previously published as Siebel SR 38-3359355721.
***Checked for relevance on 10-Nov-2014***

Symptoms

We are importing Partner Types using the EIM table EIM_ACCOUNT3 and the column PRTNR_TYPE. The vanilla column PRTNR_TYPE in the base table S_OU_PRTNR_TYPE is LOV bounded.
The LOV values for this PARTNER_TYPE are active, multilingual and translated.

We have specified the LIC values for EIM_ACCOUNT3: PRTNR_TYPE and used the EIM parameter: USE MLOV LIC = TRUE in our IFB, but the import fails with the error:

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.

According to the Change and Fix Requests below the import should work.

Fix Request ID #: 12-13OVAJ5
Change Request ID #: 12-12OXZYB
Last Modified: 20 February 2006
Fixed in Version: 7.8.2.2

If we make the LIC values the same as the display values for the PARTNER_TYPE LOV, the import works fine.

Attached is the EIM log file for the Partner Type Import.

How we can make the EIM load work properly with MLOV LIC values?

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