My Oracle Support Banner

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 JUNE 12, 2023

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

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
Goal
Solution


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