Getting ORA-00942 Table or View Does Not Exist on Profitability Analytics Dashboard (Doc ID 822693.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 4.5.39 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
OFS-PA
OBIEE

Symptoms

After installing Oracle Financial Profitability Analytics (OFS-PA), you receive the following error when opening the Oracle Interactive Dashboards:

View Display Error

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [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)

SQL Issued: SELECT "D10 Instruments"."I153-1 Acct Group" saw_0, "D15 Common Coa Id"."C003 Coa Lv3 Desc" saw_1, "D15 Common Coa Id"."C002 Coa Lv2 Desc" saw_2, "F01 Facts Avg Balances"."100-02 All Avg Bk Bal (Avg oT)"/ 1000000 saw_3, "F07 Facts Counts"."731-02 # Of Accts" saw_4, "- F019 Level Based"."100-97 All Avg Bk Bal (Avg per Acct)"/1000 saw_5, AGGREGATE(saw_3 BY saw_0), AGGREGATE(saw_4 BY saw_0), AGGREGATE(saw_5 BY saw_0), AGGREGATE(saw_3 BY saw_0, saw_2) FROM "01 FSI Profitability" WHERE ("D00 Time As Of Date"."T10 Month" = VALUEOF("OFS_BI_30_CURR_MONTH")) AND ("D10 Instruments"."I152-1 Acct Category" = 'Deposit') AND ((("D00 Time As Of Date"."T10 Month" = VALUEOF("OFS_BI_30_CURR_MONTH"))) AND (("D10 Instruments"."I152-1 Acct Category" = 'Deposit'))) AND ("D15 Common Coa Id"."C003 Coa Lv3 Desc" = '003 - Total Deposits') AND ("D10 Instruments"."I153-1 Acct Group" = 'Checking Accounts') ORDER BY saw_0, saw_3 DESC, saw_1, saw_2

As a result, nothing appears in the dashboard.

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