Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 96 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Need AP Invoice line level details i.e. Matched purchase order number and line number
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
Best Answer
-
0
Answers
-
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 :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
Subha0 -
@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.
0 -
@Subha_Tripathy-Oracle Hi Subha,
I have applied all recommended filter and I am still running into this issue.
Thanks,
Piyush
0 -
@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
0
