The Descriptive Flexfield Value Set Description feature enhances the readability of descriptive flexfield filters in available refinements. Business users get an understandable text instead of a code allowing them to apply the right refinements. The following validation types are supported:
None
Independent
Dependent
Table
To implement this feature, you first define your independent or dependent values sets or table-validated value sets. Next, update the descriptive flexfield implementation in Oracle Enterprise Command Center Framework (ECC).
Oracle Enterprise Command Center Framework then uses the descriptions of the descriptive flexfield values in the display in the dashboard.
The ECC dashboard behavior is similar to applying a refinement using a value code.
For more information on descriptive flexfields, see: Descriptive Flexfield Concepts, Oracle E-Business Suite Flexfields Guide. For more information on value sets, see: Values and Value Sets, Oracle E-Business Suite Flexfields Guide.
There are no special uptake steps for enabling the feature. The descriptive flexfield implementation enables this feature.
A profile option FND: ECC Disable DFF Value Set Description Load (internal name ECC_DFF_DISABLE_VALUESET_DESC_LOAD) can be used to disable the display of descriptive value set descriptions. This profile option is owned by Oracle Application Object Library and uses the Security hierarchy type. It is visible and updatable on the site level. The default value is null. You can set its value to a comma-separated list of descriptive flexfield names. By default, there is no descriptive flexfield name set in the profile option value, so the feature is enabled for all descriptive flexfields.
Note: Beginning with V8, Oracle Enterprise Command Center Framework has improved date and number format validation for descriptive flexfield attribute values. The respective records with data that do not have supported formats will cause failures during the data load process, and the data load will be only a partial success.