Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

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

Need AP Invoice line level details i.e. Matched purchase order number and line number

Accepted answer
103
Views
5
Comments
Piyush Ojha
Piyush Ojha Rank 1 - Community Starter
in Oracle Fusion ERP Analytics

Hi Team,

I am building visualization where I need to have invoice lines with match purchase order number and PO line number. I am using AP Expense Subject area for same.

As soon as I am adding "Purchase Order Number", i am getting invoice line repeated i.e. one line with matched PO details and one line with blank PO details.

Subject Area: Financials - AP Expense

Before Adding PO Details:

image.png

After adding Purchase order number from "Purchase Order Details", getting duplicate line with null values:

image.png

If I am trying to pull directly from Procurement Purchase Orders then getting query error.

Please let me know if this can be addressed.

Thanks,

Piyush

Best Answer

Answers

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Rank 6 - Analytics Lead

    Hi @Piyush Ojha

    Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

    There are common tips for each application which needs to be used and there are Subject Area specific guidelines which needs to be used - please make sure all tips are applied :

    https://docs.oracle.com/en/cloud/saas/analytics/24r1/faiae/appendix-report-authoring-tips-erp.html#GUID-FBBF53EC-9549-42C2-ACCD-7A6FC874D668

    Try adding the filters mentioned and see if you get correct results. If not then log an SR with the execution logs for further debugging.

    Thanks
    Subha

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Piyush Ojha - Please let us know if there has been any customisation in SME or it's the OOTB one, also share the error seen when using Procurement Purchase Orders as well. Thanks.

  • Piyush Ojha
    Piyush Ojha Rank 1 - Community Starter

    @Subha_Tripathy-Oracle Hi Subha,

    I have applied all recommended filter and I am still running into this issue.

    Thanks,

    Piyush

  • Piyush Ojha
    Piyush Ojha Rank 1 - Community Starter

    @Sumanth V -Oracle Hi Sumanth,

    There is no customization in any Subject area. I am simply building this visualization from AP Expense subject area. Oracle stores Purchase order details at invoice line level and I am trying to pull same in visualization. As soon as I pull "Purchase Order Number" attribute , it starts showing one row for same invoice line with blank Purchase order number.

    I am not sure if Oracle is trying to pull PO details one row from line level and one from header which might be creating this issue.

    Please let me know.

    Thanks,

    Piyush