Workforce Compensation: Secondary Hierarchy using lookup PER_SUPERVISOR_TYPE and Formula

We have a requirement for Secondary Hierarchy to use the Lookup type PER_SUPERVISOR_TYPE and create a Lookup code HRBP > HRL > HHR. Using the PER_EXT_HIST_ASG_SUPERVISOR_MANAGER_TYPE (DBI in FF) I managed to pull them in the Formula Log using SET_LOG but unfortunately the hierarchy rollup is not working.

Is it by design in Oracle that using Formula in Secondary Hierarchy it only requires PER_RESPONSIBILITY_TYPE (AoR)? I'm still not able to pull the proper hierarchy (EE > HRBP > HRL > HHR) or (EE > if HRBP is NULL then > HRL > HHR)