Fusion HCM OTBI : Workforce Succession Management - Incumbent Plans Real Time Subject Area message"The specified query didnt result in any data" role security (Doc ID 1683702.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Global Human Resources 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 Cloud 11.1.8 OTBI Business Intelligence


First test of a custom analysis against a newly delivered SA = Workforce Succession Management - Incumbent Plans Real Time

Expected Behavior
--------------------------
The Succession Incumbent Plan Data, which has been shown to exist in the POD, should get returned to the analysis results

Message
==========
The specified query didnt result in any data

Steps
=========
Execute the following custom analysis:

SET VARIABLE LOGLEVEL=2; SELECT
   0 s_0,
   "Workforce Succession Management - Incumbent Plans Real Time"."Succession Plan Details"."Plan Name" s_1,
   "Workforce Succession Management - Incumbent Plans Real Time"."Succession Plan Details"."Plan Type" s_2
FROM "Workforce Succession Management - Incumbent Plans Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 1000001 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