Oracle Fusion HCM Analytics

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

Categories

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

Where to find employee contract dates?

Received Response
34
Views
7
Comments
Rebecca Bot
Rebecca Bot Rank 1 - Community Starter
in Oracle Fusion HCM Analytics

Hi,
We're building KPI dashboards for HR admins and line managers and want to create overviews of new hires and ending contracts.
We're unable to find important employee dates like projected start date and contract end date. Can anyone help us locate these dates?
Thanks!

Tagged:

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Rebecca Bot -

    Could you please confirm whether you are looking for these details in FAW/FDI or OTBI? Kindly specify the application you are using, as this will help us provide better assistance.

    Thank you!

  • Rebecca Bot
    Rebecca Bot Rank 1 - Community Starter

    Hi @Sumanth V -Oracle thanks for your response!
    We're looking for these details in FAW/FDI

  • StrawberryMilkshake
    StrawberryMilkshake Rank 1 - Community Starter
    https://community.oracle.com/products/oracleanalytics/discussion/comment/62212#Comment_62212

    Hello, have you found the answer? @Sumanth V -Oracle

  • RVohra
    RVohra Rank 6 - Analytics Lead

    If I remember correctly, here’s where you generally find those dates:

    1. Projected Start Date:

    • Usually, this is associated with the Assignment or Person data.
    • In FDI templates, this date often appears under the Assignment object.
    • Field names you might see:
      • ProjectedStartDate
      • AssignmentStartDate (sometimes the actual start date if no projected date)
    • This date indicates when the employee is expected to start or started the assignment.

    2. Contract End Date

    • This is often linked to the Assignment as well, especially for contract or temporary workers.
    • Field names:
      • ContractEndDate
      • AssignmentEndDate (if related to the contract period)
    • This date specifies when the employee’s contract or assignment ends.
  • Rebecca Bot
    Rebecca Bot Rank 1 - Community Starter

    Hi @RVohra,

    Do you mean the Assignment Information in the Worker area of the HCM - Workforce Core FDI subject area?
    We can find assignment start and end dates, but the contract dates and projected start date are nowhere to be found anywhere in the Worker area.

    Assignment dates are not sufficient, for example when working with Pending Workers. In those cases, we're not interested in the assignment startdates of the PW record, but we want to know the projected start date of the employee record of that same PW.

    Interested to hear if there's a way to get those dates into Analytics!

  • RVohra
    RVohra Rank 6 - Analytics Lead

    You might need to log a SR for Oracle support to review it with the development team. Oracle Support can suggest if it needs an idea in the Idea Lab.

  • Shivaranjan
    Shivaranjan Rank 1 - Community Starter
    edited 5:46AM

    Hi @Rebecca Bot

    Employee contract details are not directly available in FDI.

    You can find them in HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVOViewAll

    We must create a data augmentation in order to extract this data.