Fusion ERP Analytics

Products Banner

How to get Master Contract Number associated with PO?

Received Response
55
Views
1
Comments
Zehra M
Zehra M ✭✭
edited March 20 in Fusion ERP Analytics

Hello,

We want to build the analysis to get the List of POs which has Master Contracts.

In Procurement-Purchase Order dimension, the Master Contract field is not available. Tried using the Enterprise Contracts - Contracts dimension along with Procurement-Purchase Order dimension but it shows Query Error as below:

Error during query processing (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.(HY000)State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid:c85ef827-6333-43d5-a9d8-eccdafdee07d-0027bf78,0:1:14:6 ts:2024-03-20T08:57:02.508+00:00].(HY000)State: HY000. Code: 43119. [nQSError: 43119] Query Failed:(HY000)State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,PO Header,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - OKC - Contract Header Details.Contract Name],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,].(HY000)State: HY000. Code: 14081. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - OKC - Contract Header Details.Contract Name, Dim - PRC - PO Header Details.Purchase Order Number (HY000)SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT0 s_0,"Enterprise Contracts - Contracts"."Contract Details"."Contract Name" s_1,"Procurement - Purchase Orders"."Document Details"."Purchase Order Number" s_2FROM "Enterprise Contracts - Contracts"FETCH FIRST 500001 ROWS ONLY


See below screenshot for reference:

Kindly advice.

Answers