My Oracle Support Banner

OTBI 'Procurement- Purchasing Real Time' Errors [nQSError: 14020] None of the fact tables are compatible with the query request Ordered Quantity (Doc ID 2782599.1)

Last updated on JUNE 29, 2021

Applies to:

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

Symptoms

OTBI report created using Subject Area "Procurement - Purchasing Real Time" errors with:

PO Charge Account.Concatenated Segments, Dim - Purchase Requestor.Unique Purchase Requestor Display Name] SB Line)]' converted to NULL because [nQSError: 14020] None of the fact tables are compatible with the query request Ordered Quantity:[DAggr(Fact - Purchasing - Order.Ordered Quantity by [ Dim - Supplier.Supplier Name, Dim - Document Status.Document Status Lookup Code, Dim - Procurement Item.Item Description, Dim - Procurement Item.Item ID, Dim - Purchase Order Details.PO Line Id, Dim - PO Charge Account.Concatenated Segments, Dim - Purchase Requestor.Unique Purchase Requestor Display Name] SB Line)].


The issue still occurs after following the steps documented in note: Error With Analysis Report - "Procurement - Purchasing Real Time" - Runtime error for service -- ADFService11G - JBO-25003: Object ShippingOrgDefinationsPEO of type Entity Usage is not found. (Doc ID 2760986.1)

Changes

 No changes

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.