Orcle Fusion OTBI: Report based on "Workforce Management - Reported Time Cards Real Time" Subject Area returns no data (Doc ID 2220575.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Fusion Time and Labor Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

When running a similar logical sql, the user gets no data back:

 

SELECT
"Workforce Management - Reported Time Cards Real Time"."Reported Time Card Details"."Time Card Start Time" s_1,
"Workforce Management - Reported Time Cards Real Time"."Reported Time Card Details"."Time Card Stop Time" s_2,
"Workforce Management - Reported Time Cards Real Time"."Time Card Status"."Time Card Status Name" s_3,
"Workforce Management - Reported Time Cards Real Time"."Reported Time Cards"."# Of Time Cards" s_4
FROM "Workforce Management - Reported Time Cards Real Time"
WHERE
(("Time Card Status"."Time Card Status Name" IS NOT NULL))
 

Solution

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