Fusion Financial General Ledger - Trial Balance analysis using General Ledger - Balances Real Time , [nQSError: 96002] Essbase Error: Login failed. Please check if server and port are correct., After BI Patch Was Applied (Doc ID 1983888.1)

Last updated on SEPTEMBER 08, 2015

Applies to:

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

Symptoms

Fusion Financials Cloud 11.1.8 OTBI / Essbase - post patch see ODBC error


later update:   can access Essbase with FRStudio


Steps
------------
Execute the following analysis against General Ledger - Balances Real Time Subject Area (data source is Essbase ):

SELECT 0 s_0, "General Ledger - Balances Real Time"."Time"."Fiscal Period" s_1, 'All' s_2, 'Total' s_3, CASE WHEN ISLEAF("General Ledger - Balances Real Time"."Balancing Segment"."Balancing Segment") THEN 1 ELSE 0 END s_4, CASE WHEN ISLEAF("General Ledger - Balances Real Time"."Cost Center Segment"."Cost Center") THEN 1 ELSE 0 END s_5, CASE WHEN ISLEAF("General Ledger - Balances Real Time"."Natural Account Segment"."Natural Account Segment") THEN 1 ELSE 0 END s_6, IDOF("General Ledger - Balances Real Time"."Balancing Segment"."Balancing Segment"."Total") s_7, IDOF("General Ledger - Balances Real Time"."Cost Center Segment"."Cost Center"."All") s_8, IDOF("General Ledger - Balances Real Time"."Natural Account Segment"."Natural Account Segment"."All") s_9, SORTKEY("General Ledger - Balances Real Time"."Time"."Fiscal Period") s_10, "General Ledger - Balances Real Time"."- Balance"."Beginning Balance" s_11, "General Ledger - Balances Real Time"."- Balance"."Ending Balance" s_12, "General Ledger - Balances Real Time"."- Balance"."Period Net Activity Credit" s_13, "General Ledger - Balances Real Time"."- Balance"."Period Net Activity Debit" s_14 FROM "General Ledger - Balances Real Time" WHERE (("Ledger"."Ledger Name" = 'FSR COA GB') AND ("- Currency Type"."Currency Type" = 'Total') AND ("Time"."Fiscal Period" IN ('p_accounting_period')) AND ("- Currency"."Apps Local Currency Code" = 'GBP') AND ("- Amount Type"."Amount Type" = 'Base') AND ("Balancing Segment"."Balancing Segment Tree Filter" = 'Company FSR COA-Company FSR COA Current') AND ("Natural Account Segment"."Account Tree Filter" = 'Account FSR COA-Account FSR COA Current') AND ("Cost Center Segment"."Cost Center Tree Filter" = 'CostCenter FSR COA-CostCenter FSR COA Current') AND ("Ledger"."Chart Of Account" = 'FSR COA') AND ("Time"."Fiscal Calendar Name" IN ('FSR COA'))) AND ((IDOF("General Ledger - Balances Real Time"."Balancing Segment"."Balancing Segment"."Total") IS NOT NULL) AND (IDOF("General Ledger - Balances Real Time"."Natural Account Segment"."Natural Account Segment"."All") IS NOT NULL) AND (IDOF("General Ledger - Balances Real Time"."Cost Center Segment"."Cost Center"."All") IS NOT NULL)) FETCH FIRST 75001 ROWS ONLY

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: 96002] Essbase Error: Login failed. Please check if server and port are correct. If you received timeout or handshake failure, please check if you tried to connect to secure port without secure keyword or clear port with secure keyword. (HY000)


Changes

 After a patch was applied

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