Looking for PO line quantity column in Purchasing Subject Areas

Sudheer YN

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.

Riyaz Ali-Oracle

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 Ali

Sudheer YN

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.

Gaurav Bharadwaj-Oracle

@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,
Gaurav

Sudheer YN

Thank you Gaurav. will do. Also i have created SR.

Rich Merkel

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.

PO Summary.catalog

PO advanced XML.txt

Sudheer YN

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.