My Oracle Support Banner

MLOV For "LOY_PT_EXP_UOM" Display All Values In Field "Effectivity UoM" In Loyalty Promotion > Promotion Rules > Assign Points (Doc ID 3075467.1)

Last updated on MARCH 10, 2025

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Siebel Loyalty Manager - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Symptoms

After configuring MLOV for the LOV 'LOY_PT_EXP_UOM' , when logging into the ESN Object Manager, the list of values in the 'Expiration UoM' field are displayed in English.

This is the only MOLV enabled that is affected.

If trying to select any value from the dropdown list in English, the error below is seen in the User Interface:

"SBL-DAT-00510": No language independent code exists for value 'Months' and type 'LOY_PT_EXP_UOM ' with language 'ESN' in table 'S_LST_OF_VAL'.(SBL-DAT-00510)


The issue can be reproduced at will with the following steps:

1- Login to the Application and add values in the language needed:

1.1 Go to Administration - Data > LOV and locate LOY_PT_EXP_UOM in English-American and Spanish (Modern) - 8 records are displayed
1.2 Make sure that the fields "Active", "Translate" and "Multilingual" are all TRUE (Checked)
1.3 Clear Cache

2- Login in ESN Object Manager to clear LOV cache in ESN just in case (could be optional but we want to avoid any cache issues in multi-lang environment) and logout

3- Login back in ESN Object Managerand go to Loyalty Promotions Administration > locate the "SN Accrual Promotion 1" and drilldown
3.1 In the Promotion Rules, drilldown in the 'SN Assign Points Rule'
3.2 Go to Actions View and focus in the "Assign Points" action record
3.3 In the bottom applet, in the section 'Vencimiento en (opcional)', enter any number in the 'Duración de vencimiento' field
3.4 Click in the field U/M de vencimiento' dropdown
3.5 The **8** values displayed are in ENGLISH

This means that the Object Manager in ESN is displaying the LIC values instead of the Display Value

Changes

 Enable MLOV - Please refer to Siebel Bookshelf > Configuring Siebel Business Applications > Localizing a Multilingual List of Values.

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.