My Oracle Support Banner

BI Publisher Analyses Using The Procurement - Purchasing Real Time Subject Area Fail To Return Data (Doc ID 2558269.1)

Last updated on JULY 12, 2021

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

Post 19A upgrade
Subject Area: Procurement - Purchasing Real Time.
  "Procurement - Purchasing Real Time"."- Time - Shipment Requested Delivery Date"."Report Date"
  "Procurement - Purchasing Real Time"."- Purchase Order Line"."Ordered Quantity"


The column Ordered Quantity does not return data on the report ("Procurement - Purchasing Real Time"."- Purchase Order Line"."Ordered Quantity" s_12) unless the column Requested Delivery Date (from Purchase Order Schedules) is deleted from the report.

The results from running this analysis is that the Quantity column is blank, while the Requested Delivery Date column does return data.


Other PO Header and PO Line data elements that are coming through just fine.

Changes

 Occurred after 19A

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.