How to create FDI report to linking the PO (Procurement module), GR (Receipt) and Invoice (AP)

User_XKAJL

Under Oracle Fusion, when create FDI report to extract the P2P process, from PO to GR to invoice. I use PO number as Join key, however, GR only link to PO, but not invoice, causing the report generated contain lots of non-matching line items.

Abdul R Shaik-Oracle

You can cross subject area analysis using Procurement Spend and Receipts subject area based on Invoice number ?

User_XKAJL

I try, for the receipts, there is no Invoice number. I need to join subject area (Procurement, Receipt and AP) and the join key is PO number.

RVohra

@User_XKAJL , Welcome to the Oracle Analytics Community!

As per my understanding, when creating a P2P report in FDI better to start with PO Distribution or PO Line.

Join Procurement subject area →Receiving subject area →Payables subject area

using PO_DISTRIBUTION_ID or PO_LINE_ID