My Oracle Support Banner

None of the fact sources for Dim - Grade Rate Details.Rate Type Meaning are compatible with the detail filter [not Dim - Grade Rate Details.Rate Type = Dim - Salary Basis.Salary Basis Name] (Doc ID 2695207.1)

Last updated on JULY 31, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to build cross-subject area based on  "Compensation - Salary Details Real Time" and "Workforce Management - Grade Rate Real Time", the following error occurs.

ERROR
-----------------------
None of the fact sources for Dim - Grade Rate Details.Rate Type Meaning are
compatible with the detail filter [not Dim - Grade Rate Details.Rate Type =
Dim - Salary Basis.Salary Basis Name]


Analysis SQL Issued
-----------------------

SELECT
  0 s_0,
  "Compensation - Salary Details Real Time"."Business Unit"."Business Unit Name" s_1,
  "Compensation - Salary Details Real Time"."Legal Employer"."Name" s_2,
  "Compensation - Salary Details Real Time"."Location"."Region 1" s_3,
  "Compensation - Salary Details Real Time"."Location"."Worker Location Name" s_4,
  "Compensation - Salary Details Real Time"."Location"."Worker Location Postal Code" s_5,
  "Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Name" s_6,
  "Compensation - Salary Details Real Time"."Worker Legislation"."Territory Short Name" s_7,
  "Compensation - Salary Details Real Time"."Worker"."Assignment Number" s_8,
  "Compensation - Salary Details Real Time"."Worker"."Assignment Status Type" s_9,
  "Compensation - Salary Details Real Time"."Worker"."Employee Date Of Birth" s_10,
  "Compensation - Salary Details Real Time"."Worker"."Employee First Name" s_11,
  "Compensation - Salary Details Real Time"."Worker"."Employee Gender" s_12,
  "Compensation - Salary Details Real Time"."Worker"."Employee Last Name" s_13,
  "Compensation - Salary Details Real Time"."Worker"."Employee Mailing Address Line2" s_14,
  "Compensation - Salary Details Real Time"."Worker"."Employee Mailing Address Line1" s_15,
  "Compensation - Salary Details Real Time"."Worker"."Employee Mailing City Name" s_16,
  "Compensation - Salary Details Real Time"."Worker"."Employee Name" s_17,
  "Compensation - Salary Details Real Time"."Worker"."Enterprise Hire Date" s_18,
  "Compensation - Salary Details Real Time"."Worker"."Person Number" s_19,
  "Compensation - Salary Details Real Time"."Worker"."Person Type" s_20,
  "Compensation - Salary Details Real Time"."Worker"."Primary National Identifier Number" s_21,
  "Compensation - Salary Details Real Time"."Worker"."Termination Date" s_22,
  "Workforce Management - Grade Rate Real Time"."Grade Rate Details"."Name" s_23,
  "Workforce Management - Grade Rate Real Time"."Grade Rate Details"."Rate Type" s_24,
  "Workforce Management - Grade Rate Real Time"."Grade"."Effective End Date" s_25,
  "Workforce Management - Grade Rate Real Time"."Grade"."Effective Start Date" s_26,
  "Workforce Management - Grade Rate Real Time"."Grade"."Grade Name" s_27,
  DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Business Unit"."Business Unit Name") s_28,
  DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker Legislation"."Territory Short Name") s_29,
  DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker"."Assignment Status Type") s_30,
  DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker"."Employee Gender") s_31,
  DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker"."Person Type") s_32,
  DESCRIPTOR_IDOF("Workforce Management - Grade Rate Real Time"."Grade Rate Details"."Rate Type") s_33,
  "Compensation - Salary Details Real Time"."Salary"."Current Salary" s_34,
  "Workforce Management - Grade Rate Real Time"."Grade Rate"."Rate Value Count" s_35
FROM "Workforce Management - Grade Rate Real Time"
WHERE
((DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker"."Assignment Status Type") = 'ACTIVE')
AND (DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker"."Person Type") IN ('300000000291434.00', '300000000291435.00'))
AND ("Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Name" IN ('Hourly', 'Salary'))
AND ("Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Status" = 'A')
AND ("Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Name" <>  DESCRIPTOR_IDOF("Workforce Management - Grade Rate Real Time"."Grade Rate Details"."Rate Type") ))

 

Same analysis runs without any error when the following filter is removed:

....
AND ("Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Name" <>  DESCRIPTOR_IDOF("Workforce Management - Grade Rate Real Time"."Grade Rate Details"."Rate Type") )

 

 

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
References


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