Fusion HCM OTBI: No data returned ..."The specified criteria did not result in any data" for the "Hierarchy" (Tree) Folder for Department, after the Tree structure had been updated (Doc ID 1663602.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

On :  Fusion Applications HCM Cloud 11.1.7.0.0 , Custom OTBI analysis (using seeded SA)

Expected behavior
------------------------
Custom analysis should return data  for  "Compensation - Workforce Compensation Real Time"."- Hierarchy"."Tree Name"  and    "Compensation - Workforce Compensation Real Time"."Department"."Department Name"
The analysis uses Fusion Tree / Hierarchy for Departments

Actual behavior
---------------------
Analysis returns no data  "The specified criteria did not result in any data"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use the following attributes to build an analysis.
 SELECT
   "Compensation - Workforce Compensation Real Time"."- Hierarchy"."Tree Name" s_1,
   "Compensation - Workforce Compensation Real Time"."Department"."Department Name" s_2
FROM "Compensation - Workforce Compensation Real Time"

Cause

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