Purchasing

Get Involved. Join the Conversation.

Topic

    Sathya Kannan
    Procurement - Procure to Pay Real TimeAnswered
    Topic posted October 16, 2019 by Sathya KannanBlue Ribbon: 750+ Points, tagged Business Intelligence, Create Requisition, How-To, Orders, OTBI, Payables, Requisition Processing, Setup, White Paper 
    94 Views, 5 Comments
    Title:
    Procurement - Procure to Pay Real Time
    Summary:
    Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POs
    Content:

    Hi,

    We would like to create an OTBI report using the Procurement - Procure to Pay Real Time analysis, but the receipt number (available under Invoice column) created for the Purchase orders is not displayed.

    Does anyone know the solution for this?

     

    Regards,

    Sathya Kannan

    Best Comment

    Manavalan Ethirajan

    Hi Sathya,

    The current design is that ‘Receipt is tied to invoice in P2P subject area'. If invoice has the corresponding receipt, then it will show in the report along with the invoice attribute/metrics. However, if the receipt is only tied to PO and no invoice has been created, the receipt will not show. In P2P Subject Area, we support two functional areas, PO and Invoice. We do have requisition attributes as well receipt attributes. The other 2 areas (Requisition and Receipt) are treated like attributes tied to the 2 main areas, those (requisition and receipt) are not standalone functional areas.

    Thanks,

    Manav

    Comment

     

    • Dev Thota

      Sathya,

      Please create a separate report for receipts and link PO number action to receipts report it will work correctly.

       

      Thanks,

      Dev Thota.

    • Sathya Kannan

      Hi,

       

      Are you telling me to link the OTBI for Receiving and P2P?

       

      Regards,

      Sathya Kannan

    • Manavalan Ethirajan

      Hi Sathya,

      The current design is that ‘Receipt is tied to invoice in P2P subject area'. If invoice has the corresponding receipt, then it will show in the report along with the invoice attribute/metrics. However, if the receipt is only tied to PO and no invoice has been created, the receipt will not show. In P2P Subject Area, we support two functional areas, PO and Invoice. We do have requisition attributes as well receipt attributes. The other 2 areas (Requisition and Receipt) are treated like attributes tied to the 2 main areas, those (requisition and receipt) are not standalone functional areas.

      Thanks,

      Manav

    • Sathya Kannan

      Thanks, Manav.

       

      We receive the POs and so the receipt numbers get created. Are you saying we can't view the receipts if they are not directly tied to invoices? In order to view the invoices and receipts associated with the Purchase Orders, I should write a BI report then? and there's no OTBI analysis given by Oracle?

       

      Regards,

      Sathya Kannan

       

       

       

    • Jess Mullenix

      Due to security rights many users do not have access to the AP side to view receipts. There should be a way to pull all receipt numbers tied to a PO from the Procure to Pay Real Time section. Currently there is not, it will only show receipts if they are tied directly to an invoice and that does not show the entire picture.

       

      Jess