Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to get Master Contract Number associated with PO?

Received Response
195
Views
1
Comments
Zehra M
Zehra M Rank 2 - Community Beginner
edited Mar 20, 2024 9:14AM in Oracle 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:

image.png

Kindly advice.

Tagged:

Answers

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod

    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