Price And Quantity are returning Null for Amount Line Type other than 'Goods' in the "Procurement - Purchasing Real Time" Subject Area

Last updated on JULY 22, 2015

Applies to:

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