My Oracle Support Banner

On Data Export, The Column That Includes The Meaning Of A Custom PickList Value Is Blank. (Doc ID 2073752.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


There is a custom field MSegment_c that has a picklist. One of the values on the picklist needs to change which is named as Industrial/Commercial . Rather than create a new value with the new name and migrate all affected records to the new value, you wish to change the display name (meaning) of the value.

During an export the MSegment_c Meaning column is blank. MSegment_c contains the look up value on the export. You are currently meeting some reporting requirements by doing an analysis on exported data with an external system. Because MSegment_c Meaning is blank, the only option is to use the lookup code in the analysis. The lookup code value is no longer desired, you only want the meaning to display instead.

The behavior is observed in all custom fields that contain a picklist.


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

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