Oracle Fusion Data Intelligence

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

Adding People Group and Service Dates using Data Augmentation

Received Response
134
Views
5
Comments
Vasanthakumar Ravi
Vasanthakumar Ravi Rank 3 - Community Apprentice

Summary:

Adding People Group and Service Dates using Data Augmentation

Content (required):

We are trying to bring the people group field and service dates (Enterprise Start Date, Legal employer Start Date, etc,.) using Data Augmentation. Can you please guide me to select the source tables (refer the attached screenshot).

Thanks in advance.

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

22.R4.P1

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


Answers

  • Hello Vasanth ,


    Services dates are already available in Workforce Core subject area. Additional seniority dates ( Enterprise Hire Date ,Enterprise Seniority Date , Legal Employer Seniority Date & Person Start Date ) will be exposed in the upcoming FAW release.


    The list that you have in your screenshots is BI VO list. So you need to select appropriate VO.

    Also , on people group - would you be able to share the exact use case that you are trying to achieve by getting this additional information in the subject area ?

  • Vasanthakumar Ravi
    Vasanthakumar Ravi Rank 3 - Community Apprentice

    Hi @Nupur Joshi-Oracle

    Thanks for the reply.

    On people group - we have a requirement to use this field into DV Filter condition and Parameters. Can you please share the VO name if you have.

    Regards,

    Vasanth

  • Orange
    Orange Rank 5 - Community Champion

    Hi Vasanth,

    Please try source table HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentPVO. It has an attribute name AssignmentPEOPeopleGroupId.

    Kind regards

  • Vasanthakumar Ravi
    Vasanthakumar Ravi Rank 3 - Community Apprentice

    Hi @Orange ,

    Thanks for the update.

    We have tried this HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentPVO source table but its not returning any data also this source table is not showing the Segment columns.

    Please help on the same.

    Regards,

    Vasanth

  • Amrit
    Amrit Rank 3 - Community Apprentice

    Hi Vasantha,

    Did you get the any solution to this?

    Thanks and Regards,

    Amrit