Oracle Transactional Business Intelligence

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

Workforce Management - Work Relationship Real Time: filter by Action

Accepted answer
21
Views
1
Comments
MDSchoonover-Oracle
MDSchoonover-Oracle Rank 1 - Community Starter

Summary:

To find Action field for hire/rehire etc from the subject area or similar: Workforce Management - Work Relationship Real Time

Content (required):

I am having issues finding the Action field in this subject area or others so that I can filter the data I am receiving based on the action of Hire, Rehire, Global Transfer etc. Is there anywhere that I can find this information/field in the analysis tool?




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

23

Best Answer

  • Patrick_Midd
    Patrick_Midd Rank 3 - Community Apprentice
    Answer ✓

    Try "Workforce Management - Worker Assignment Event Real Time".

    Assignment Event Details folder should have most of what you're looking for.

    "Assignment Event Details"."Action Code" and "Assignment Event Details"."Effective Start Date" would be a good place to start.

    Sample analysis attached for reference. Should show all assignment event activity where "Action Code" = 'HIRE' by effective start date, as well as some basic employee info.

    To add this report to your environment:

    1. Create a new analysis using Oracle Business Intelligence Answers.
    2. Copy and paste the XML from the attached document into the Advanced tab.
    3. Click Apply XML.
    4. Save the analysis

    Subject areas used: Workforce Management - Worker Assignment Event Real Time