Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OTBI Analysis - Getting DFF meaning instead of the value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Analysis - Getting DFF meaning instead of the value

edited Mar 22, 2018 2:24PM in General Transactional Reporting (OTBI) 5 comments



I am developing an OTBI analysis that deals with several DFF from Oracle HCM Cloud. These DFF have value sets that get values from lookups loaded into the system containing meaningless codes as values. The DFF then store values but on UI, they always show the meaning. However, the OTBI analysis extracts just the value but not the meaning.

I found on Fusion Applications OTBI (Reporting) FAQ For Descriptive Flexfields (DFF) (Doc ID 1503455.1) a workaround that requires to manually define the meaning for each value, which is quite difficult to maintain over the time so I was wondering if anyone knows another way of managing my requeriment.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!