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

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

PROBLEM STATEMENT
=================

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.

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