Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Performance Issue - Time Management Overview - Workforce Management - Reported Time Cards Real Time
Summary:
A customer is experience Performance Issues in OTBI - Workforce Management - Reported Time Cards Real Time
';SELECT
0 s_0,
COUNT(DISTINCT "Workforce Management - Reported Time Cards Real Time"."Reported Time Cards"."Time Card Submitted Time") s_1
FROM "Workforce Management - Reported Time Cards Real Time"
WHERE
(("Time Card Status"."Time Card Status Name" = 'Submitted') AND ("Worker"."Manager User Name" = VALUEOF(NQ_SESSION."USER")))
FETCH FIRST 250001 ROWS ONLY
The Query Times out
HY000. Code: 60009. [nQSError: 60009] The user request exceeded the maximum query governing execution time. (HY000)
This similar to FUSION HCM Team Time Card fusion screen but as a tile on a LM dashboard
Tagged:
0