Error Codes: E4BHSJTH:OPR4ONWY:U9IM8TAC:OI2DL65P When Trying to Drill Down in ALMBI Forecast Balance Sheet Detail Report (Doc ID 1591466.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


In Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.0, when trying to drill down in the Forecast Balance Sheet Detail in Consolidated Currency report, the following error is displayed:

An error occurred while trying to generate drill down query.
  Error Details

Location: saw.connect.bipsdrilldown, saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <SELECT>: Syntax error [nQSError: 26012] . (HY000)
SQL Issued: {CALL NQSGenerateDrillDownQuery('SELECT Currency."Cons Currency"|| '' )'' saw_6, case WHEN "Product"."Account Type" IN (100.00, 200.00) then ''Total Assets'' WHEN "Product"."Account Type" IN (300, 400.00, 500.00) then ''Total Liabilities'' end saw_0, "Product"."Product Name Level19" saw_1 FROM "ALM BI" WHERE ("Product"."Account Type" IN (100, 200, 300, 400, 500)) AND ("Process Scenario"."Process Name" = ''HNB_ALM_Static_Proc'') AND ("Process Scenario"."Scenario Name" = ''Base'') AND ("Calendar - ALM Results"."As-of-Date" = SELECT Max("Calendar - ALM Results"."As-of-Date" ) FROM "ALM BI" WHERE "Process Scenario"."Proc Scen Key" = "Standard Cash Flow Results"."Proc Scen Skey" AND "Calendar - ALM Results"."Row Wid" = "Standard Cash Flow Results"."As of Date Skey" AND "Process Scenario"."Process Name"in(''HNB_ALM_Static_Proc'') order by "Calendar - ALM Results"."As-of-Date" DESC)','2','''LKR )'',''Total Assets'',''Inflows''','-1 -1 -1 -1 -1 -1 -1','0,1')}

Steps to reproduce
The issue can be reproduced at will with the following steps:

1. Attempt to drill down in Forecast Balance Sheet Detail in Consolidated Currency report.


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