Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

HCM - Position subject area showing Assignment Category Code rather than Assignment Category Name

Accepted answer
24
Views
4
Comments
A.J.
A.J. Rank 3 - Community Apprentice
in Oracle Fusion Data Intelligence

When I pull in the Assignment Category from the HCM - Positions subject area, the results that I see are the Assignment Category Code, and not the Assignment Category name.

Maybe this is being caused by something that my organization has configured incorrectly but it doesn't appear so to me.

From what I can tell from the SQL generated, it is because the join of DW.ASSIGNMENT_CATEGORY_D_TL does not include a join on ASSIGNMENT_CATEGORY but rather has a join between ASSIGNMENT_CATEGORY and LANGUAGE (D1.c3 = D2.c2) which is causing the join to fail and therefore the NVL is always producing the ASSIGNMENT_CATEGORY from DW_POSITION_D and never the ASSIGNMENT_CATEGORY_NAME from DW_ASSIGNMENT_CATEGORY_D_TL.

image.png

Am I reading this correctly? Or is there something I should fix on my end?

Tagged:

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach
    Answer ✓

    Hi @A.J.,

    I didn't realize it when I first responded but we did have a Bug on this and it was scheduled to be fixed in the 25.R2 release.

    For your reference, the Bug number is: 37830535

    Regards,

    John

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hello @A.J..

    Your results are a little unexpected. This issue may require a SR.

    As a test, could you replace your Assignment Category Code and Assignment Category from the HCM - Positions Subject Area with the same from the HCM - Workforce Core Subject Area as follows:

    image.png

    It would be interesting to see if you get different results.

    Regards,

    John Whitaker

  • A.J.
    A.J. Rank 3 - Community Apprentice

    Thanks John,

    The Assignment Category from HCM - Workforce Core works just fine and I see the value from DW_ASSIGNMENT_CATEGORY_D_TL.ASSIGNMENT_CATEGORY_NAME because the code does a join using the ASSIGNMENT_CATEGORY:

    image.png

    You mention an SR, which I am happy to open an SR if this is something specific to how my organization configured things. I just guessed that since HCM - Positions was delivered, that it might be more widespread and something worth asking on the community.

    Please let me know.

    Thanks,

    A.J.

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/comment/68491#Comment_68491

    Very helpful information.

    Thanks for sharing @JohnW-Oracle!