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

Piyush Ojha

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:

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

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

Subha_Tripathy-Oracle

Hi @Piyush Ojha ,

Please log an SR and upload execution logs for further analysis.

Thanks
Subha

Subha_Tripathy-Oracle

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

@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

@Subha_Tripathy-Oracle Hi Subha,

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

Thanks,

Piyush

Piyush Ojha

@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