Using Participant Details Subject Area In BI Report Causes Java Errors - nQsError: 10058 A general error has occurred (Doc ID 1634647.1)

Last updated on MAY 22, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.7.0.0 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Application Toolkit - Version 11.1.7.0.0 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.7.0.0 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Incentive Compensation - Version 11.1.7.0.0 to 11.1.7.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------
ODBC driver returned an error (SQLExecDirectW)

error details
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



STEPS
-----------------------
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


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