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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

Fast Formula to extract Manager ID (Person Number)

edited Jan 25, 2021 9:19PM in HCM Integrations 2 comments

Summary

any ideas?

Content

Hello,

In my extract I have assignment ID. How to calculate Manager ID (Person Number)?

Currently we have this value set, but is not working. 

PER_ASSIGNMENT_SUPERVISORS_F MH, PER_ALL_PEOPLE_F PEF, PER_ALL_ASSIGNMENTS_M MA

PEF.PERSON_ID = MH.MANAGER_ID
                          AND MA.PERSON_ID = MH.PERSON_ID
                          AND MA.ASSIGNMENT_TYPE IN ('E','C','P')
                          AND MA.PRIMARY_FLAG = 'Y' 
                          AND EXISTS
                              (SELECT 1 
                              FROM
                              PER_ASSIGNMENT_SUPERVISORS_F PASF
                              WHERE MA.PERSON_ID = PASF.MANAGER_ID)
                          AND TRUNC(SYSDATE) BETWEEN MH.EFFECTIVE_START_DATE AND MH.EFFECTIVE_END_DATE 
                                                  AND TRUNC(SYSDATE) BETWEEN MA.EFFECTIVE_START_DATE AND MA.EFFECTIVE_END_DATE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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