Fusion Applications - Cross Subject Area - None of the fact sources for Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF are compatible with the detail filter (Doc ID 2959494.1)

Last updated on JULY 05, 2023

Applies to:

Symptoms

Cross Subject area analysis built using "Workforce Management - Person Real Time" and "Workforce Management - Worker Assignment Real Time" fail with:

Error:

[nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid [[

[nQSError: 14023] None of the fact sources for Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_....GL___Costing_Segment_glDeptid are compatible with the detail filter [Dim - Job.Job Code = '0107' or Dim - Job.Job Code = '02' or Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid = '100' or Dim - Job.Job Code = '100' or Dim - Job.Job Code = '100' or Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid = '100'].

[nQSError: 43119] Query Failed:

Go to Advanced Tab to see the following SQL:

SET VARIABLE QUERY_SRC_CD='Report',SAW_SRC_PATH='/users/00......',PREFERRED_CURRENCY='User Preferred Currency 1',DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1,LOGLEVEL=7;SELECT
  0 s_0,
  "Workforce Management - Person Real Time"."Person Extra Information_... GL Costing Segment"."Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid" s_1,
  "Workforce Management - Worker Assignment Real Time"."Department"."Department Name" s_2,
  "Workforce Management - Worker Assignment Real Time"."Job"."Job Code" s_3,
  "Workforce Management - Worker Assignment Real Time"."Worker"."Person ID" s_4,
  "Workforce Management - Worker Assignment Real Time"."Worker"."Person Number" s_5,
  "Workforce Management - Person Real Time"."Person"."Person Count" s_6,
  "Workforce Management - Worker Assignment Real Time"."Worker Assignment"."Head Count" s_7
FROM "Workforce Management - Worker Assignment Real Time"
WHERE
((RIGHT("Department"."Department Name",5) = '100') AND ((("Workforce Management - Person Real Time"."Person Extra Information_... GL Costing Segment"."Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid" = '100') OR ("Job"."Job Code" IN ('100', '100'))) OR (("Workforce Management - Person Real Time"."Person Extra Information_... GL Costing Segment"."Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid" = '101') OR ("Job"."Job Code" IN ('100', '100')))))
ORDER BY 6 ASC NULLS LAST, 5 ASC NULLS LAST, 2 ASC NULLS LAST, 4 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 500001 ROWS ONLY



[nQSError: 14023] None of the fact sources for Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid are compatible with the detail filter [Dim - Job.Job Code = '100' or Dim - Job.Job Code = '100' or Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid = '100' or Dim - Job.Job Code = '100' or Dim - Job.Job Code = '100' or Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_..._GL___Costing_Segment_glDeptid = '100'].

[nQSError: 43119] Query Failed:

Changes

Cause

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