Income Statement Variance Analysis Showing A Query Using Ago Must Reference A Time Dimension

(Doc ID 1924243.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


On : 6.1.1 version

When attempting to view Income Statement Variance Analysis, the following error appears.

View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
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: 22062] A query using Ago must reference a Time dimension. (HY000)

1. New installation of Oracle Financial Services Enterprise Financial Performance Analytics 6.1.1.
2. Ran dimension loading, time dimension, ledger stat transformation successfully.
3. Navigate to the Dashboard Income Statement Variable Analysis and received the above error.


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