Error While Generating The Auxiliary Report For Mexico (Doc ID 2216402.1)

Last updated on DECEMBER 29, 2016

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Financial Reporting and Analysis

While running the Auxiliary report for Mexico from BI user were getting the below error:

ERROR
-----------------------
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT NumCta saw_0, DesCta saw_1, SaldoIni saw_2, SaldoFin saw_3, Fecha saw_4, NumUnIdenPol saw_5, Concepto saw_6, Debe saw_7, Haber saw_8, Accounting_Period saw_9, Ledger saw_10, Legal_Entity saw_11 FROM (SELECT "General Ledger - Transactional Balances Real Time"."Account"."General Ledger Code Combination Identifier" bal_ccid, "General Ledger - Transactional Balances Real Time"."Ledger"."Ledger Name" Ledger, "General Ledger - Transactional Balances Real Time"."Time"."Fiscal Period" Accounting_Period, "General Ledger - Transactional Balances Real Time"."Natural Account Segment"."Account Code" NumCta, "General Ledger - Transactional Balances Real Time"."Natural Account Segment"."Account Description" DesCta, "General Ledger - Transactional Balances Real Time"."- Balance"."Beginning Balance" SaldoIni, "General Ledger - Transactional Balances Real Time"."- Balance"."Ending Balance" SaldoFin, "General Ledger - Transactional Balances Real Time"."- Balance"."Period Net Activity" bal_periodbal FROM "General Ledger - Transactional Balances Real Time" where "General Ledger - Transactional Balances Real Time"."Ledger"."Ledger Name" in ('ClubCorp Mexico Ledger') and "General Ledger - Transactional Balances Real Time"."Time"."Fiscal Period" in ('Per10-16') ) balances full outer join (SELECT "General Ledger - Journals Real Time"."- Header Details"."Header Default Effective Date" Fecha, "General Ledger - Journals Real Time"."- Account"."General Ledger Code Combination Identifier" jrnl_ccid, CONCAT(REPLACE("General Ledger - Journals Real Time"."- Header Details"."Header Name",' ',''),CONCAT(REPLACE(CAST("General Ledger - Journals Real Time"."- Header Details"."Header Key" AS CHAR),' ',''),CONCAT(REPLACE("General Ledger - Journals Real Time"."- Batch Details"."Batch Name",' ',''),REPLACE("General Ledger - Journals Real Time"."- Header Details"."Header Description",' ','')))) jrnl_header_desc, CONCAT(REPLACE("General Ledger - Journals Real Time"."- Header Details"."Header Name",' ',''),CONCAT(REPLACE(CAST("General Ledger - Journals Real Time"."- Header Details"."Header Key" AS CHAR),' ',''),REPLACE("General Ledger - Journals Real Time"."- Batch Details"."Batch Name",' ',''))) NumUnIdenPol, "General Ledger - Journals Real Time"."- Ledger"."Ledger Name" jrnl_ledger, "General Ledger - Journals Real Time"."Time"."Fiscal Period" jrnl_period, "General Ledger - Journals Real Time"."- Line Details"."Line Description" Concepto, "General Ledger - Journals Real Time"."- Line Details"."Line Number" jrnl_line_number, "General Ledger - Journals Real Time"."- Lines"."Journal Line Accounted Amount Debit" Debe, "General Ledger - Journals Real Time"."- Lines"."Journal Line Accounted Amount Credit" Haber, "General Ledger - Journals Real Time"."- Header Details"."Journal Legal Entity" Legal_Entity FROM "General Ledger - Journals Real Time" where "General Ledger - Journals Real Time"."- Ledger"."Ledger Name" in ('ClubCorp Mexico Ledger') and "General Ledger - Journals Real Time"."Time"."Fiscal Period" in ('Per10-16') and "General Ledger - Journals Real Time"."Posting Status"."Posting Status Code" = 'P' and "General Ledger - Journals Real Time"."- Header Details"."Journal Legal Entity" in ('@{p_legal_entity}')) journals on journals.jrnl_ledger = balances.Ledger and balances.bal_ccid = journals.jrnl_ccid and journals.jrnl_period = balances.Accounting_Period WHERE (Accounting_Period = 'Per10-16') AND (Ledger = 'ClubCorp Mexico Ledger') ORDER BY saw_0, saw_1, saw_4, saw_5, saw_6, saw_9, saw_10, saw_11

Changes

Auxiliary Report for Mexico uses flex segments and it is mandatory to execute BI extender Job before using these flex segments in the report.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms