Oracle Transactional Business Intelligence

Home› Oracle Analytics› Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Received Response
201
Views
7
Comments
PamS
PamS ✭✭✭
in Oracle Transactional Business Intelligence

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):

Tagged:

Answers

  • MandeepGupta
    MandeepGupta ✭✭✭✭

    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
    PamS ✭✭✭

    Thanks Mandeep,

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

    Pam

  • ravikiran goda-Oracle
    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
    Srinivas Pendyala-Oracle ✭✭✭

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

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle ✭✭✭✭

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

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


  • Becca Edwards
    Becca Edwards ✭

    Hi @Gaurav Bharadwaj-Oracle, the links above go to the same blank header page for Administering Analytics and Reports for HCM.

    Both links just take me here:

    image.png

    Can you help with fresh links?

    I'm trying to find which Subject Area(s) the Inventory DFF go into. I ran the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process, but cannot locate my new DFFs. The DFF is BI Enabled checked in Manage Descriptive Flexfields.
    I ran the Import Oracle Fusion Data Extensions For Transactional Business Intelligence ESS job and don't see the new DFF in any inventory Subject Areas.

    Thanks for any guidance!

  • Nathan CCC
    Nathan CCC ✭✭✭✭✭

    Becca,

    The links were to a chapter/section inside older the 22b version of document FAHCA "Administering Analytics and Reports for HCM". But this stale link has taken you up to the "title" page of latest version 24C of the same document in this case 24C. So the good news is you are in the correct document.

    Just search for or look through the table of contents in this document.

    You will find the 2 topics "Descriptive Flex Fields" and "Overview of Configuration".

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

    ttps://docs.oracle.com/en/cloud/saas/human-resources/24c/fahca/human-capital-management-descriptive-flexfields-for-oracle.html#s20047246