Hi everyone,
I have two separate reports that I would like to run. Both run fine on their own, but when adding all the columns to one of the reports I get multiple errors and it will not work. I've watched many YouTube videos, specifically this one, Reporting using more than one Fusion OTBI subject area - YouTube
I did everything in this video. I have a measure that is in both subject areas and I submitted the dimensional SQL code. Below are the errors. Does anyone know what I can do or can reference another YouTube video?
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail: [left(Dim - AP Account.Concatenated Segments , 4)],[Dim - AP Transaction Status.Invoice Status Type Name],[Dim - AP Disbursement Details.Pay Doc Payment Document Name, Dim - AP Disbursement Details.Check Date, Dim - AP Disbursement Details.Status Meaning, Dim - AP Disbursement Details.Check Status lookup Code, Dim - AP Disbursement Details.Check Number],,
,,,,,Details,,,,,[Dim - AP Transaction Details.Invoice Number, Dim - AP Transaction Details.Type1099, Dim - AP Transaction Details.Invoice Entered Date, Dim - AP Transaction Details.Invoice Date, Dim - AP Transaction Details.Invoice ID Drill],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Supplier Sites.Site Address Address Line 1, Dim - Supplier Sites.Site Address Postal Code, Dim - Supplier Sites.Site Address Address Line 2, Dim - Supplier Sites.Site Address Address Line 3, Dim - Supplier Sites.Site Address Address Line 4, Dim - Supplier Sites.Site Address City, Dim - Supplier Sites.Site Address State, Dim - Supplier Sites.Site Address Country],,
[Dim - Supplier.Supplier Number, Dim - Supplier.Supplier Name, Dim - Supplier.Tax Payer ID, Dim - Supplier.Tax Organization Type, Dim - Supplier.SupplierOrganizationTypeLookupCode],,,,,
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 14025. ,
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 14025.
Please have your System Administrator look at the log for more details on this error. (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 - AP Disbursement Details.Check Date, Dim - AP Disbursement Details.Check Number, Dim - AP Disbursement Details.Check Status lookup Code, Dim - AP Disbursement Details.Pay Doc Payment Document Name, Dim - AP Disbursement Details.Status Meaning, Dim - AP Transaction Details.Invoice Date, Dim - AP Transaction Details.Invoice Entered Date, Dim - AP Transaction Details.Invoice ID Drill, Dim - AP Transaction Details.Invoice Number, Dim - AP Transaction Details.Type1099, Dim - AP Transaction Status.Invoice Status Type Name, Dim - Business Unit.Business Unit Key, Dim - Supplier Sites.Site Address Address Line 1, Dim - Supplier Sites.Site Address Address Line 2, Dim - Supplier Sites.Site Address Address Line 3, Dim - Supplier Sites.Site Address Address Line 4, Dim - Supplier Sites.Site Address City, Dim - Supplier Sites.Site Address Country, Dim - Supplier Sites.Site Address Postal Code, Dim - Supplier Sites.Site Address State, Dim - Supplier.Supplier Name, Dim - Supplier.Supplier Number, Dim - Supplier.SupplierOrganizationTypeLookupCode, Dim - Supplier.Tax Organization Type, Dim - Supplier.Tax Payer ID, left(Dim - AP Account.Concatenated Segments , 4)
Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1;SELECT 0 s_0, "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Date" s_1, "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Entered Date" s_2, "Payables Invoices - Transactions Real Time"."- General Information"."Invoice ID" s_3, "Payables Invoices - Transactions Real Time"."- Invoice Line Details - Income Tax and Withholding Information"."Type1099" s_4, "Payables Invoices - Transactions Real Time"."- Reference Information"."Payment Status Name" s_5, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 1" s_6, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 2" s_7, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 3" s_8, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 4" s_9, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address City" s_10, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Country" s_11, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Postal Code" s_12, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address State" s_13, "Payables Invoices - Transactions Real Time"."Business Unit"."Business Unit Name" s_14, "Payables Invoices - Transactions Real Time"."Business Unit"."Default Legal Entity Name" s_15, "Payables Invoices - Transactions Real Time"."Supplier"."Supplier Name" s_16, "Payables Invoices - Transactions Real Time"."Supplier"."Supplier Number" s_17, "Payables Invoices - Transactions Real Time"."Supplier"."Tax Organization Type" s_18, "Payables Invoices - Transactions Real Time"."Supplier"."Tax Payer ID" s_19, "Payables Payments - Disbursements Real Time"."- General Information"."Invoice Number" s_20, "Payables Payments - Disbursements Real Time"."- Other Information"."Pay Doc Payment Document Name" s_21, "Payables Payments - Disbursements Real Time"."- Payment Information"."Check Date" s_22, "Payables Payments - Disbursements Real Time"."- Payment Information"."Check Number" s_23, "Payables Payments - Disbursements Real Time"."- Payment Information"."Payment Status" s_24, "Supplier - Supplier Real Time"."- Income Tax"."Federal Reportable" s_25, "Supplier - Supplier Real Time"."- Income Tax"."Supplier Income Tax type" s_26, DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."Business Unit"."Business Unit Name") s_27, DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."Supplier"."Tax Organization Type") s_28, DESCRIPTOR_IDOF("Payables Payments - Disbursements Real Time"."- Payment Information"."Payment Status") s_29, left("Payables Invoices - Transactions Real Time"."- Distribution Combination"."Concatenated Segments",4) s_30, "Payables Invoices - Transactions Real Time"."- Invoice Amounts"."Invoice Amount" s_31, "Payables Payments - Disbursements Real Time"."- Invoice Installment Amounts"."Payment Amount" s_32, "Payables Payments - Disbursements Real Time"."- Payments Accounting"."SLA Unrounded Accounted Amount Credit" s_33 FROM "Payables Invoices - Transactions Real Time" WHERE ((DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."Business Unit"."Business Unit Name") = 300000028208707) AND ("- Reference Information"."Payment Status Name" IN ('Fully paid', 'Partially paid'))) FETCH FIRST 250001 ROWS ONLY
