You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Need Fast Formula expression for Manager Type

    edited Feb 1, 2019 10:28PM in Human Capital Management 2 comments

    Summary

    Need Fast Formula expression for Manager Type

    Content

    Hi All,

              I have a requirement to capture whether a person has Functional Manager or not and then based on that set flag as Y or N. Currently we have two types of Managers 1. Functional Manager 2.Line Manager. Everyone will have line Manager but select few will have matrix Manager.

    Now I am trying to use an expression: l_Mgr_type(variable)= PER_ASG_MGR_MANAGER_TYPE  to get Mgr type associated with the person and then using the logic that: if l_Mgr_Type= 'Functional Manager' then set flag as Y. Now, this logic is not working as I have no clue what value is getting captured as part of PER_ASG_MGR_MANAGER_TYPE. I am not sure what happens if a person has both line and Functional Manager.  Can you please help me which database item should be used and how this expression should look like

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!