Fusion HCM OTBI - Workforce Profiles - Model Profile Real Time - no Data Returned "the specified criteria didn't result in any data" (Doc ID 1983375.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Fusion HCM 11.1.8 Cloud -  data role security for seeded Subject Area Workforce Profiles - Model Profile Real Time

Cannot run reports in OTBI on Model Profiles.  
When  try and run a report on the Subject Area:  Workforce Profiles - Model Profile Real Time
and on the folder Model Profile Details.  No data is returned.  


Unexpected behavior
--------------------------------
the specified criteria didn't result in any data

roles supplied: HR Analyst_ViewAll, Workforce Profile Transaction Analysis Duty is available in both HCM and OBI stripes

Steps
------------
SELECT
   0 s_0,
   "Workforce Profiles - Model Profile Real Time"."-  Model Profile Details"."Profile Name" s_1
FROM "Workforce Profiles - Model Profile Real Time"
ORDER BY 1, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

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