My Oracle Support Banner

Fusion Global HR : Selecting Data That Shows As Populated Does Not Return Any Result (Doc ID 1585167.1)

Last updated on FEBRUARY 04, 2019

Applies to:

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



No data is returned when building a BI Report that pulls from more than one subject area.  If the data is pulled from a single business area (EX. Workforce Management - Worker assignment Event Real Time or Workforce Management – Worker Assignment Real Time ), data is returned.   However, when trying to pull from both subject areas together (i.e. joined subject areas) the same data that was just verified does not show.

The screen returns "No rows returned."

Steps to Recreate

  1. Login to Fusion UI. 
  2. Navigator > Reports and Analytics
  3. Create report that pulls employee name attribute from worker folder.
      Verify that the data is available.
  4. Create report that fetches grade attribute.
       Verify that the data is available.
  5. Create a report to pull both pieces of info together, no data is returned.

 Confirm the user has the below two roles are already added:
      Human Resource Specialist
      Line Manager

Expected Behavior
BI reports should be able to be generated using data from different Subject Areas to create complete reports.


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

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