My Oracle Support Banner

Error "No fact table exists at the requested level of detail" When Crossing "Incentive Compensation - Participant Compensation Plan Real Time" and "Incentive Compensation - Participant Period Goals Real Time" (Doc ID 2503766.1)

Last updated on OCTOBER 31, 2019

Applies to:

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

Symptoms

On : 11.13.18.05.0 version, Analytics

Getting error when doing a cross join between two subject areas

SQL:

ENABLE_DIMENSIONALITY=1;SELECT
   0 s_0,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Business Unit"."Business Unit Name" s_1,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Compensation Plan"."End Date" s_2,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Compensation Plan"."Start Date" s_3,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant"."Participant ID" s_4,
   "Incentive Compensation - Participant Period Goals Real Time"."Business Unit"."Default Currency" s_5,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant"."Participant Name" s_6,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant"."Party Number" s_7,
   "Incentive Compensation - Participant Period Goals Real Time"."Performance Measure"."Formula Name" s_8,
   'Amount' s_9,
   CASE WHEN "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Compensation Plan"."Start Date" <"Incentive Compensation - Participant Period Goals Real Time"."Calendar"."Start Date" THEN "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Compensation Plan"."Start Date" END s_10,
   DESCRIPTOR_IDOF("Incentive Compensation - Participant Compensation Plan Real Time"."Business Unit"."Business Unit Name") s_11,
   NULL s_12,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Performance Measure"."Alternate Target 1" s_13,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Performance Measure"."Alternate Target 2" s_14,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Performance Measure"."Alternate Target 3" s_15,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Performance Measure"."Alternate Target 4" s_16,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Performance Measure"."Alternate Target 5" s_17,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Performance Measure"."Target" s_18,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Plan Component"."Individualized Target Incentive" s_19,
   "Incentive Compensation - Participant Compensation Plan Real Time"."Participant Plan Component"."Target Incentive Weight" s_20,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant Period Goal"."Alternate Target Interval 1" s_21,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant Period Goal"."Alternate Target Period 1" s_22,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant Period Goal"."Alternate Target Period 2" s_23,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant Period Goal"."Alternate Target Period 3" s_24,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant Period Goal"."Alternate Target Period 4" s_25,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant Period Goal"."Alternate Target Period 5" s_26,
   "Incentive Compensation - Participant Period Goals Real Time"."Participant Period Goal"."Target Period" s_27
FROM "Incentive Compensation - Participant Period Goals Real Time"
WHERE
((("Incentive Compensation - Participant Compensation Plan Real Time"."Participant Plan Component"."Target Incentive Weight" <> 0) AND ("Performance Measure"."Formula Name" NOT LIKE '%LEAST%') AND ("Performance Measure"."Formula Name" NOT LIKE '%TI WT%') AND ("Performance Measure"."Formula Name" NOT LIKE 'Period%') AND ("Performance Measure"."Formula Name" NOT LIKE 'KSO 2%') AND ("Participant"."Active Flag" = 'Y')))
ORDER BY 1, 2 ASC NULLS LAST, 12 ASC NULLS LAST, 3 ASC NULLS LAST, 6 ASC NULLS LAST, 7 ASC NULLS LAST, 8 ASC NULLS LAST, 9 ASC NULLS LAST, 10 ASC NULLS LAST, 4 ASC NULLS LAST, 13 ASC NULLS LAST, 11 ASC NULLS LAST, 5 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY



ERROR
-----------------------

[nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Participant Compensation Plan Details.Start Date, Dim - Participant Compensation Plan Details.End Date],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Period Calendar.Start Date],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Performance Measure.Formula Name],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Details,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,].
[nQSError: 43119] Query Failed:

]]


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Below are the columns used in the first subject area - "Incentive compensation -Participant Period Goal Details"

- Business unit  - 1) Business unit 2) Territory 3) Language 4) Currency code
- Performance Measure 1) Goal name 2) Performance Interval 3) Unit of Measure
- Calendar -1) Start Date 2) End date
- Participant Period Goal - 1) Goal 2)Alternate Target Period 1 3) Alternate Target Period 2 4) Alternate Target Period 3 5) Alternate Target Period 4 6) Alternate Target Period 5
- Participant - 1)Participant 2) Party Number 3) E-mail address 4) Person number 5) Update all occurences
- Compensation Plan - 1) Plan name
- Plan component - 1) Plan component name

2) Below are the columns used in the second subject area - "Incentive compensation - Participant Plan compensation details"

- Participant - 1) Participant (Hidden)
-Participant Performance measures - 1) Alternate Target 1 2) Alternate Target 2 3) Alternate Target 3 4) Alternate Target 4 5) Alternate Target 5 6) Total Target  ( All hidden)
- Participant Plan component - 1) Individualised Target Incentive 2)Target Incentive weight

 


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot build a custom report

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.