Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Can't find a proper join when attempting to join a custom subject area to an augmentation table.

Accepted answer
21
Views
2
Comments

I am very new to FDI. I am trying to bring data from the augmented table (Job Application History Event Details - Contains all history for job applications states phases) into a custom subject area I created - from The Talent Acquisition subject area in FAW. I found multiple identifiers in the augmented table, but all the identifiers from the augmentation table are numeric and the ones from the custom subject area are doubles. I can't find out any information related to this.

Are you only supposed to only join on entity keys?

Thanks very much!

Best Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle ✭✭✭✭✭
    Answer ✓

    @JDCal - The best practice is always to join on entity keys as unique value identifying each row in table would help avoiding data consistency errors when doing the analytics. Thanks!.

  • JDCal
    JDCal ✭✭✭
    Answer ✓

    Makes sense, thanks Sumanth!