Skip to Main Content

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Approver's Name not coming for multiple Approver's ID

User_17PTQDec 14 2022

Hello,
I am trying to fetch the name of approver in my query and I am using wft.approvers (wft - fa_fusion_soainfra.wftask) for fetching the approver IDs but while fetching those IDs I found that sometimes multiple approvers IDs are coming like 2233,2233,2233 and in that case of multiple occurences of employee IDs I am unable to fetch multiple approver name.
Can anyone suggest any query or method which I can use to fetch multiple approver name for multiple approver IDs.
Note: I am able to fetch the approver Name when only single approver ID is coming.

Comments
Post Details
Added on Dec 14 2022
0 comments
428 views