We have a requirement to pull employee name in the OTBI report if the DFF field has employee number . Does OTBI support this scenario to fetch lookup values into the report?
Yes OTBI has the capability to get data from additional information fields. When you configure the descriptive flexible field you must set "BI Enabled" = True. You must also run the biextender scheduled process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" with parameter HCM so that the system can update the metadata repository database (PRD) to add the attribute presentation columns for the DFFs into all the subject areas so that you can use them in your logical queries. If the DFF is configured as a lookup then you will get both a code and a description presentation column created in the subject area. So expect the code presentation column will have the person number and the description presentation column will have the person name.
