Custom BI Report Based on Subject Area Attainments Real Time Errors : Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

(Doc ID 1923886.1)

Last updated on MARCH 03, 2015

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version and later
Oracle Fusion Incentive Compensation - Version and later
Information in this document applies to any platform.


When attempting to run a custom dashboard report that is based on Incentive Compensation - Attainments Real Time subject area,
the following error occurs.

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:
Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Incentive Compensation - Attainments Real Time"."Calendar"."Period Name" s_1, "Incentive Compensation - Attainments Real Time"."Participant"."Participant Name" s_2, SORTKEY("Incentive Compensation - Attainments Real Time"."Calendar"."Period Name") s_3, CASE "Incentive Compensation - Attainments Real Time"."Compensation Plan"."Compensation Plan Name" WHEN 'Teller Plan - Full Time' THEN CASE FILTER("Incentive Compensation - Attainments Real Time"."Attainment Transaction"."Output Achieved" USING (("Incentive ...

1. Create an analysis based on subject area "Incentive Compensation - Attainments Real Time"
2. Add filters: Period = June 2014, Participant = Lorenzo


There are two Incentive Compensation administrator users.

Both users (Eric and Matt) have role Incentive Compensation Manager My Test BU.

However, user Eric ran the same report and results return within seconds whereas user Matt gets the error.

Eric also had the role Incentive Compensation Participant Manager.


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