OTBI Error: The User Request Exceeded The Maximum Query Governing Execution Time. while pulling Natural Account Code from the SLA account. (Doc ID 2490854.1)

Last updated on FEBRUARY 07, 2024

Applies to:

Goal

Error while running the report with below given sql

SELECT
0 s_0,
"Receivables - Transactions Real Time"."- General Information"."Transaction Date" s_1,
"Receivables - Transactions Real Time"."- General Information"."Transaction Number" s_2,
"Receivables - Transactions Real Time"."- General Information"."Transaction Source Name" s_3,
"Receivables - Transactions Real Time"."- General Information"."Transaction Type" s_4,
"Receivables - Transactions Real Time"."- Line Information"."Line Description" s_5,
"Receivables - Transactions Real Time"."- Natural Account Segment Value"."Account Code" s_6,
"Receivables - Transactions Real Time"."Bill-to Customer Account"."Bill-to Customer Account Number" s_7,
"Receivables - Transactions Real Time"."- Line Amounts"."Line Amount" s_8,
"Receivables - Transactions Real Time"."- Tax Amounts"."Tax Amount" s_9
FROM "Receivables - Transactions Real Time"
WHERE
(("- General Information"."Transaction Source Name" <> 'CONVERSION') AND ("- Natural Account Segment Value"."Account Code" = 'xxxxx') AND ("- General Information"."Transaction Date" BETWEEN date '2018-10-31' AND date '2018-11-13'))
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 4 ASC NULLS LAST, 5 ASC NULLS LAST, 8 ASC NULLS LAST, 6 ASC NULLS LAST, 7 ASC NULLS LAST
FETCH FIRST 250001 ROWS ONLY

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation at OCI call OCIStmtFetch. (HY000)

State: HY000. Code: 60009. [nQSError: 60009] The user request exceeded the maximum query governing execution time. (HY000)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.