Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

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

Received Response
15
Views
3
Comments
User_XKAJL
User_XKAJL Rank 1 - Community Starter
in Oracle Fusion AI Data Platform Forum

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.

Answers

  • Abdul R Shaik-Oracle
    Abdul R Shaik-Oracle Rank 3 - Community Apprentice

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

  • User_XKAJL
    User_XKAJL Rank 1 - Community Starter

    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
    RVohra Mod

    @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