How to fetch LOV values and meaning into a new field?

(Doc ID 2186785.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Fusion Sales - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

We have a requirement that,in contact object,we have one LOV field and Long text field will be available.

We need to fetch the LOV(multi selected) meaning and lookup codes into Long text using map.

we need the values example: lookup meaning values are like: Prefix,Middle name,Favorite contact.
  lookup code values are like: EMMA TEST1,EMMA TEST2,EMMA TEST3.

But,we are getting the output like: Prefix,Middle name,Favorite contact, EMMA TEST 1,EMMA TEST2 ,EMMA TEST3

But we need the output like: Prefix: EMMA TEST1 , Middle name: EMMA TEST2,Favorite contact :EMMA TEST3
 

Solution

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