Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Jennifer Bruce
    Procure-to-Pay RT subject area - approver name
    Topic posted September 6, 2019 by Jennifer BruceBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, OTBI, Reports 
    31 Views, 1 Comment
    Title:
    Procure-to-Pay RT subject area - approver name
    Summary:
    Procure-to-Pay RT subject area - approver name
    Content:

    I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject area didn't exist when I wrote my initial reports, so they currently run in BIP across the following tables:

    "FUSION"."POR_REQUISITION_HEADERS_ALL" "POR_REQUISITION_HEADERS_ALL",
     "FUSION"."POR_REQUISITION_LINES_ALL" "POR_REQUISITION_LINES_ALL",
     "FUSION"."HZ_PARTIES" "HZ_PARTIES",
     "FUSION"."POZ_SUPPLIERS" "POZ_SUPPLIERS",
     "FUSION"."GL_CODE_COMBINATIONS" "GL_CODE_COMBINATIONS",
     "FUSION"."PO_LINE_LOCATIONS_ALL" "PO_LINE_LOCATIONS_ALL",
     "FUSION"."PO_DISTRIBUTIONS_ALL" "PO_DISTRIBUTIONS_ALL",
     "FUSION"."PO_HEADERS_ALL" "PO_HEADERS_ALL",
     "FUSION"."PO_LINES_ALL" "PO_LINES_ALL",
     "FUSION"."AP_INVOICE_LINES_ALL" "AP_INVOICE_LINES_ALL",
     "FUSION"."AP_INVOICES_ALL" "AP_INVOICES_ALL"

     

    The subject area seems to have most of the information that I need, but I can't see a field for the requisition approver name (we are able to bring this back through our BIP data model).  Has anyone else found it, or is this something that hasn't been made visible in the subject area?  It's a critical bit of information for us, as the requisition approver will be the person being held to account for requisitions created after the invoice date. 

     

    Thanks for any help you can offer

    Jenny

     

     

    Comment