My Oracle Support Banner

Fusion Applications OTBI: Data returned is incorrect - Head Count And Assignment Count , security data role (Doc ID 1906509.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

Fusion HCM Cloud 11.1.7 unepected null result for headount


Steps
---------
Implementation consultant\HR Analyst executes the following analysis

SELECT
  0 s_0,
  "Workforce Management - Worker Assignment Real Time"."Business Unit"."Business Unit Name" s_1,
  "Workforce Management - Worker Assignment Real Time"."Worker Assignment"."Assignment Count" s_2,
  "Workforce Management - Worker Assignment Real Time"."Worker Assignment"."Head Count" s_3
FROM "Workforce Management - Worker Assignment Real Time"
ORDER BY 1, 2 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

BU Name Assignment Count Head Count

x 0
y 0
z 0

headcount column is blank

Cause

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
Symptoms
Cause
Solution
References


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