Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to extract expense reports which are reassigned to different approver

Summary: We are trying to expense reports which are reassigned from one approver to another approver.

Content (required):

I tried to query below tables but could not frame query to obtain below columns:

Tables used:

FUSION.FND_BPM_TASK_VL,

 FUSION.FND_BPM_TASK_HISTORY_B

Required Columns in report:

  1. Expense report number
  2. Expense date
  3. First Approver
  4. Reassigned Approver to
  5. Reassigned By

Do you have any query which can be used to extract above columns.

Below tables are not extracting any data in our environment:

  1. FA_FUSION_SOAINFRA.WFTASK
  2. FA_FUSION_SOAINFRA.WFTASKHISTORY

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!