OTBI Report for Current Invoice Approver

Question

I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver.

Gaurav Bharadwaj-Oracle · Answer

@BillW

You might find the right assistance in this forum, please log a thread there.

ERP Analytics

Regards,

Gaurav

kholt · Answer

I am trying to build the same report (current approver only). Has anyone successfully done this? I tried all of the suggested filters and MAX on action date by invoice id, but still returns multiple approvals.

BillW · Answer

Thanks for the information.

But I'm still having troubles when a reassign happens.  I need to show last Approver (not all approvers assign) or MAX per invoice ID.

I used :( MAX("Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action Date" By "Payables Invoices - Transactions Real Time"."- General Information"."Invoice ID")  on the filter but still listing each approver on the invoice.

The Filters

* Approval Status is equal to / is in  Initiated
* Approval Action is equal to / is in  Assigned to; Delegated to; Escalated to; Information requested from; Reassigned to

Thanks