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 OCTOBER 28, 2019
Applies to:
Oracle Fusion Incentive Compensation - Version 11.1.7.0.0 and laterOracle 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 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |