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

Last updated on SEPTEMBER 21, 2016

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

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