Future Approvers for Requisitions are not visible in Oracle Base Tables
We are building a Report which needs to show a Requisition's Future Approver Names.
In a Requisition Approval Process, we have two kinds of Approval Process
- Parallel Approver Hierarchy
- Sequential Approver Hierarchy
We are facing the issue in Sequential Hierarchy Case.
Issue Description:
We have the scenario where Approver1 has Approved the Requisition and later it got assigned to Approver2.
We also have Approver3, Approver4 and Approver5. These 3, 4 and 5 have not been assigned but are visible at the UI and can be considered as Future Approvers.
In the above case, Approver 1 and 2 are available in the Base Table('FA_FUSION_SOAINFRA.WFTASKHISTORY') because they have either Approved/Assigned Status.
0