My Oracle Support Banner

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 JANUARY 16, 2018

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.8.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

To view full details, 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 a vibrant support community of peers and Oracle experts.