How to Create a Cross Subject Area Report on Incentive Compensation Transaction and Credits Real Time to Display Flexfield Attributes. (Doc ID 1667327.1)

Last updated on JULY 12, 2017

Applies to:

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

Goal

How to create an cross subject report on multiple subject areas (eg. Incentive Compensation - Transactions Real Time and Incentive Compensation - Credits Real Time)

Example:

1.  Create a new analysis in BI
2.  Select the following columns from the following subject area:
     Subject Area:  Incentive Compensation - Credits Real Time
          Columns:
              Credit Category.Credit Category Name
              Credit Transaction Details.Source Transaction Number
              Participant.Participant Name
     Subject Area : Incentive Compensation - Transaction Real Time
          Columns:
              Source Transaction Details.Source Transaction Number
3.  Click on Results tab

 

If the setup is not correct, user can potentially get errors similar to :

Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
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: 14025] No fact table exists at the requested level of detail:
[,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Dim - Participant.Participant Name],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Dim - Participant Transaction Details.Source Transaction Number],,,[Dim - Participant Credit Details.Source Transaction Number],,,,,,,,
[Dim - Credit Category.Credit Category Name],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency', ENABLE_DIMENSIONALITY=1; SELECT 0 s_0,
"Incentive Compensation - Credits Real Time"."Credit Category"."Credit Category Name" s_1,
"Incentive Compensation - Credits Real Time"."Credit Transaction Details"."Source Transaction Number" s_2,
"Incentive Compensation - Credits Real Time"."Participant"."Participant Name" s_3,
"Incentive Compensation - Transactions Real Time"."Source Transaction Details"."Source Transaction Number" s_4
FROM "Incentive Compensation - Credits Real Time" FETCH FIRST 65001 ROWS ONLY

 

 

 

Solution

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