My Oracle Support Banner

EBS Adaptors: Purchase Requisition Details are Extracted from Unsupported Fact Tables (Doc ID 1391076.1)

Last updated on OCTOBER 08, 2019

Applies to:

Business Intelligence Applications Observer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.

Symptoms

When reporting on Purchase Requisition Details in Procurement and Spend - Purchase Orders subject area, the logical query generated uses fact tables (such as Fact_W_PURCH_RCPT_F, Fact_W_PURCH_ORDER_F etc..) which are not supported for EBS adaptors. As a result, measures are showing as 0 values when Fact Attributes are added to the OBIEE report containing Requisition Details.

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


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