Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to get Master Contract Number associated with PO?
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
-
Hi @Zehra M
Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.
I would request you to create a SR with the Instance details for further troubleshooting.
Thanks
Subha
0 -
Hi I would like to know this as well. Can we share the outcome of the SR with the group?
2 -
Hello, please share the results?
0
