Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Looking for PO line quantity column in Purchasing Subject Areas
Hi,
I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real Time. But its showing blank. Then tried to calculate it with Line Amount/Price, but it will return zero if line price is 0.
May i know which column has to be used to fetch PO Line Quantity.
Thank you,
Regards,
Sudheer.
Answers
-
Hi Sudheer,
“Line Quantity”
This is often the most reliable column for PO line quantity.
If it’s not visible in your current subject area, try switching to:Procurement – Purchase Orders Real Time
Procurement – Purchasing Agreements Real Time (if you're working with blanket POs)“Quantity Ordered” or “Quantity”
These may appear under the Purchase Order Line or Purchase Order Distribution folders.
Check the below:
Looking for PO line quantity column in Purchasing Subject Areas — Cloud Customer Connect
Thanks,
Riyaz Ali0 -
Hi @Riyaz Ali-Oracle , Thank you. I dont see any subject are with the name . Purchasing Agreements is for Agreements but i am looking for POs.
"Procurement – Purchase Orders Real Time"
Created SR for the same.
0 -
@Sudheer YN
You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance.
SCM/PRC Analytics
Regards,
Gaurav1 -
Thank you Gaurav. will do. Also i have created SR.
0 -
Hi,
See if this works in your instance, you may need both line and distribution sequence for it to appear.
You also mentioned about blank, double check you currency settings from the catalog my account → preferences → currency. In our instance I set to ledger currency.
Attached is the xml (you can go to advanced and replace what is in the analysis xml and click apply). I have defaulted PO as a filter, so you can modify that as needed/etc.
Also attaching archive file that you could also unarchive in your instance.
Hope this helps/works.
2 -
Thank you @Rich Merkel . I have created an SR and working with them. Its showing null because of 3 columns Requester, Project Number and Expenditure Organization columns. If i remove these columns from my report, its showing ordered qty.
0
