Using Participant Details Subject Area In BI Report Causes Java Errors - nQsError: 10058 A general error has occurred
Last updated on DECEMBER 01, 2017
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 1.0]
Oracle Fusion Application Toolkit - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Oracle Fusion Application Toolkit Cloud Service - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Oracle Fusion Incentive Compensation - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 1.0]
Information in this document applies to any platform.
On : 11.1.7 , Manage Incentive Comp
When attempting to add the column 'Home Currency code' from the Paysheet details subject area to a BI report, the report receives a Java error.
ODBC driver returned an error (SQLExecDirectW)
error codes OPR4ONWY:U9IM8TAC:OI2DL65P
nQsError: 10058 A general error has occurred
Incorrectly defined logical table source ( for fact table Z - VO OBIA ETL) does not contain mapping for [dim - Performance measure.formula name, Dim - Performance measure.Incentive Compensation
The issue can be reproduced at will with the following steps:
1. Created reporting using subject area
2. Earning and Attainment
3. Participant Compensation Plan
4. Paysheet Summary Real Time
The report works untill 'Home currency code' attribute is added from paysheet details.
The moment this field is added, we are getting Java/odbc errors
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms