Where do I find DFF's in subject area Workforce Management - Documents of Record Real Time

PamS

Summary:

I am attempting to build a report using the Workforce Management - Documents of Record Real Time

I have managed to get to the Document Type Vacation Carryover Approval but I need to also include a couple of descriptive flex fields in my report

Can someone please help me find these fields in the Subject Area (if they are available) or do I have to build this report using SQL?

Is there a way to map a field on the screen back to a table/subject area?

If I need to change to SQL - how do I know which tables I have to use?

TIA

Pam

Content (required):

Workforce Management - Documents of Record Real Time

Version (include the version you are using, if applicable):

Building the report in 21D (currently in our TEST environment)

Code Snippet (add any code snippets that support your topic, if applicable):

Mandeep Gupta

Hi Pam,

Can you please confirm if you have run Import Oracle Fusion Data Extensions for Transactional Business Intelligence process? While defining the flexfield attributes, check the BI enabled checkbox and then run this process.

The flexfields will start appearing in the SA. You will be easily identify the attribute from name in SA.

Thanks.

PamS

Thanks Mandeep,

I will check with the team to see if this has been run

Pam

ravikiran goda-Oracle

HI Pam,

Please make sure the below process is completed successfully.

Import Oracle Fusion Data Extensions for Transactional Business Intelligence

Srinivas Pendyala-Oracle

Please provide the DFF code to check & help with the folder name in the OTBI subject area.

Gaurav Bharadwaj-Oracle

Please review this documentation to understand where you will find the DFFs :

https://docs.oracle.com/en/cloud/saas/human-resources/22b/fahca/human-capital-management-descriptive-flexfields-for-oracle.html#s20047246

The entire process describing how to enable DFFs is provided here :

https://docs.oracle.com/en/cloud/saas/human-resources/22b/fahca/overview-of-transactional-business-intelligence-configuration-of.html#s20056832