Oracle Transactional Business Intelligence

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

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to fetch the lookup codes and lookup Types created in Fusion HCM into OTBI report

Received Response
6
Views
1
Comments
KarthikDamamkar
KarthikDamamkar Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Hello All,

we are using a OTBI analysis (Subject Area - Workforce Learning - Learning Records Real Time) to fetch the Learning Records for a few particular courses. so, we have hardcoded courses what we want to fetch. to avoid the hardcoding of the courses and offering we want to use custom lookup values (lookup_code) created in fusion HCM.

How to fetch these lookup values and lookup types in the OTBI report.

appreciate if some one can help me through this.

Tagged:

Answers

  • RVohra
    RVohra Rank 6 - Analytics Lead

    I donot think you can directly select lookup values in OTBI from standard HCM subject areas.

    Go to BI Publisher (BIP) → Create a Data Model with Query like below

    SELECT LOOKUP_TYPE,
    LOOKUP_CODE,
    MEANING
    FROM FND_LOOKUP_VALUES_VL
    WHERE LOOKUP_TYPE = 'XX_LEARNING_COURSES'
    AND ENABLED_FLAG = 'Y';

    Save it as a BIP Dataset (XML or CSV output).

    In OTBI, create a data model join (via BI Publisher “combined data model” feature) or schedule this BIP extract and use it as a lookup table in a subject area filter.

    Please update here if it works.

    Hope it helps!