Price And Quantity are returning Null for Amount Line Type other than 'Goods' in the "Procurement - Purchasing Real Time" Subject Area
(Doc ID 2035102.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Fusion Purchasing Cloud Service - Version 11.1.9.2.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.1.9.2.0 version, Technology Management - Reports/Analytics
ACTUAL BEHAVIOR
---------------
Price and Quantity are not showing for the 'Amount' line type when creating BI Analytics for Purchasing
You have selected "Procurement - Purchasing Real Time" subject area for creating a Purchase Order report.
On the PO line, when the line type is other than 'Goods', the Price and Order quantity is not showing any value.
You used a similar logical SQL in your report:
SELECT
0 s_0,
"Procurement - Purchasing Real Time"."- Distribution Destination Type"."Destination Type Lookup Code" s_1,
"Procurement - Purchasing Real Time"."- GL Account"."Concatenated Segments" s_2,
"Procurement - Purchasing Real Time"."- Line Ship To Location"."Ship To Location Name" s_3,
"Procurement - Purchasing Real Time"."- Procurement Item"."Category Name" s_4,
"Procurement - Purchasing Real Time"."- Procurement Item"."Item Description" s_5,
"Procurement - Purchasing Real Time"."- Purchase Order Line Detail"."Line Number" s_6,
"Procurement - Purchasing Real Time"."- Purchase Order Line Detail"."Price" s_7,
"Procurement - Purchasing Real Time"."- Purchase Order Schedule Detail"."Need By Date" s_8,
"Procurement - Purchasing Real Time"."- Purchasing Line Type"."Purchase Line Type Code" s_9,
"Procurement - Purchasing Real Time"."Bill To Business Unit"."Bill To Business Unit Name" s_10,
"Procurement - Purchasing Real Time"."Bill To Location"."Bill To Location Name" s_11,
"Procurement - Purchasing Real Time"."Buyer"."Purchase Buyer Name" s_12,
"Procurement - Purchasing Real Time"."Document Status"."Document Status Meaning" s_13,
"Procurement - Purchasing Real Time"."Payment Terms"."Payment Terms Name" s_14,
"Procurement - Purchasing Real Time"."Procurement BU"."Default Currency" s_15,
"Procurement - Purchasing Real Time"."Procurement BU"."Procurement Business Unit Name" s_16,
"Procurement - Purchasing Real Time"."Purchase Order Document Style"."Document Type" s_17,
"Procurement - Purchasing Real Time"."Purchase Order Header Detail"."Description" s_18,
"Procurement - Purchasing Real Time"."Purchase Order Header Detail"."Order" s_19,
"Procurement - Purchasing Real Time"."Requisitioning BU"."Requisition Business Unit Name" s_20,
"Procurement - Purchasing Real Time"."Sold To Legal Entity"."Sold To Legal Entity Name" s_21,
"Procurement - Purchasing Real Time"."Supplier Profile"."Supplier Name" s_22,
"Procurement - Purchasing Real Time"."Supplier Site"."Supplier Site Code" s_23,
"Procurement - Purchasing Real Time"."- Purchase Order Distribution"."Distribution Ordered Quantity" s_24,
CASE WHEN "Procurement - Purchasing Real Time"."- Purchasing Line Type"."Purchase Line Type Code" ='Amount' THEN "Procurement - Purchasing Real Time"."- Purchase Order Line Detail"."Price" ELSE "Procurement - Purchasing Real Time"."- Purchase Order Line Detail"."Price"*"Procurement - Purchasing Real Time"."- Purchase Order Distribution"."Distribution Ordered Quantity" END s_25
FROM "Procurement - Purchasing Real Time"
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |