Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Report for Current Invoice Approver

Received Response
218
Views
4
Comments
BillW
BillW Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

Answers

  • Anders W. Langholm
    Anders W. Langholm Rank 5 - Community Champion

    Perhaps you could find some help in this:

    Need report that shows all approval assignees who have NOT approved invoice — Cloud Customer Connect (oracle.com)

  • BillW
    BillW Rank 1 - Community Starter

    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

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

    Thanks

  • kholt
    kholt Rank 1 - Community Starter

    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.

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

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

    ERP Analytics

    Regards,
    Gaurav