Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Query to extract expense reports which are reassigned to different approver — Cloud Customer Connect
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

Received Response
2
Views
1
Comments

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!