Cloud Platform

Hi Everyone,

Below is the Fast formula to get Employee Super Manger details

EX: Employee → Manager → Manager

For this, we have to create a Value set first and attach the same to the Fast formula.

********VS Query************

Select

SUPERVISOR_NAME.FULL_NAME

From

PER_ASSIGNMENT_SUPERVISORS_F PASF, PER_ALL_PEOPLE_F SUPERVISOR, PER_PERSON_NAMES_F SUPERVISOR_NAME, PER_ALL_PEOPLE_F PAPF, PER_ALL_ASSIGNMENTS_F PAAF,PER_PERSON_NAMES_F PPNF

Where 1=1
AND PASF.MANAGER_ID = SUPERVISOR.PERSON_ID
AND PASF.MANAGER_TYPE = 'LINE_MANAGER'
AND SUPERVISOR_NAME.PERSON_ID = SUPERVISOR.PERSON_ID
AND SUPERVISOR_NAME.NAME_TYPE = 'GLOBAL'
AND SYSDATE BETWEEN PASF.EFFECTIVE_START_DATE AND PASF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN SUPERVISOR.EFFECTIVE_START_DATE AND SUPERVISOR.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN SUPERVISOR_NAME.EFFECTIVE_START_DATE AND SUPERVISOR_NAME.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID = PAAF.PERSON_ID
AND PAAF.EFFECTIVE_LATEST_CHANGE = 'Y'
AND PAAF.ASSIGNMENT_STATUS_TYPE ='ACTIVE'
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE
AND PAAF.ASSIGNMENT_TYPE = 'E'
AND PAAF.PRIMARY_FLAG = 'Y'
AND PAPF.PERSON_ID = PASF.PERSON_ID
AND PPNF.PERSON_ID = PAPF.PERSON_ID
AND PPNF.NAME_TYPE = 'GLOBAL'
AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
AND papf.person_id = :{PARAMETER.PERSON_ID}

Fast formula - Type should be Extract Rule

DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT
INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)
l_value = ' '
l_Manager = ' '

IF DATA_ELEMENTS.EXISTS('EMP_Manger_ID') THEN
(
l_Manager = DATA_ELEMENTS['EMP_Manger_ID']

                l\_value = GET\_VALUE\_SET('VS Name',  
                                   '|=PERSON\_ID='''||'l\_Manager'||'''')      
                                      
              RULE\_VALUE = l\_value  
             )  

RETURN RULE_VALUE

Thanks,

Mahesh