The Received Amount is NULL in Purchase Details. (Doc ID 1313069.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Applications Consumer - Version: 7.9.6.2 [AA 1830] and later   [Release: V7 and later ]
Information in this document applies to any platform.

Goal


When customers use the standard 7.9.6.2 RPD and run a report using Procurement and Spend - Purchase Orders with the following columns "Purchase Details"."Purchase Order Number" , Fact."Received Amount" then the Received Amount is returned as null the Query it fires is

The standard 7.9.6.2 RPD for Procurement and Spend Analytics---using subject area Procurement and Spend - Purchase Orders the report Received Amount is returned as null

The query issued;-


WITH
SAWITH0 AS (select distinct T92539.PURCH_ORDER_NUM as c1
from
W_PROJECT_D T167120 /* Dim_W_PROJECT_D_Project */ ,
W_PURCH_COST_F T92539 /* Fact_W_PURCH_COST_F */
where ( T92539.DELETE_FLG = 'N' and T92539.PROJECT_WID = T167120.ROW_WID and T167120.PROJECT_NUMBER = 'M0024' ) )
select distinct SAWITH0.c1 as c1,
cast(NULL as DOUBLE PRECISION ) as c2
from
SAWITH0
order by c1

wrong fact table it should be using W_PURCH_SCHEDULE_LINE_F instead of W_PURCH_COST_F


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms