Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

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
50
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