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.
You can cross subject area analysis using Procurement Spend and Receipts subject area based on Invoice number ?
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.
@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
