My Oracle Support Banner

View Display Error and ORA-00942 on ALMBI 05 Liquidity Risk > CounterBalancing Dashboard (Doc ID 1442797.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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

Symptoms

In the Oracle Financial Services Asset Liability Management Analytics (ALMBI) 5.6 Dashboards, when you go to the "05 Liquidity Risk" > "CounterBalancing" report, all sections of the Dashboard return a "View Display Error" and "Odbc driver returned an error (SQLExecDirectW)" as shown below:



If you click on Error Details, the following error is displayed:

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: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

You expect all ALMBI Dashboards to display results successfully.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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