Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion HCM Analytics

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Logic to find the Next Approver Name for the resignation process

Received Response
51
Views
1
Comments
KeerthanaBaskaran
KeerthanaBaskaran Rank 3 - Community Apprentice
in Oracle Fusion HCM Analytics


We have a requirement to build a resignation report, in that we need fetch the Current approver and Next approver. We are able to get the Current approver from the table 'fa_fusion_soainfra.WFTASK' and column 'assigneesdisplayname'.


But we are not able to fetch the Next approver if the resignation process approval is pending with Current approver.


Kindly suggest a solution.

Tagged:

Answers