TBUI - Task Based UI Multilingual List Of Values (MLOV) Pre-Default Value Gives Error No Language Independent Code Exists For Value SBL-DAT-00510 (Doc ID 1200664.1)

Last updated on OCTOBER 03, 2016

Applies to:

Siebel Hospitality - Version 8.0 [20405] and later
Information in this document applies to any platform.

*** Checked for currency on 03-Oct-2016 ***

Symptoms

When a pre-default value is specified for a Multilingual List of Values (MLOV) field in a TBUI Task, an error will be generated.

This can be shown as follows:

1. Configure the Account Type field to be MLOV  (i.e., so that the LIC is stored on the database rather than the LOV display value).

   Table: S_ORG_EXT

   Column: OU_TYPE_CD

   Translate = TRUE

   Translate Table Name = S_LST_OF_VAL

2. For LOV: Add display value Test Type 1 with LIC value "TEST_TYPE_01" for LOV Type 'ACCOUNT_TYPE', translate = true

3. On the Account BC, field Type maps to OU_TYPE_CD.

4. Set pre-default value to

Expr: "LookupValue(""ACCOUNT_TYPE"", ""TEST_TYPE_01"")"


5. Create new account in Accounts screen: specify Test Type 1 for account type field. Save. Check the database and OU_TYPE_CD = TEST_TYPE_01, the LIC value.

6. Create a simple task to add a new Account.

7. Publish, Activate and Administer this task.

When this task is executed, the following error occurs:

No language independent code exists for value 'TEST_TYPE_01' and type 'ACCOUNT_TYPE' with language 'ENU' in table 'S_LST_OF_VAL'.(SBL-DAT-00510)

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