OBIA 11g HR Workforce Profile FTE Fact Incorrect Includes Deleted Assignment (Doc ID 1962501.1)

Last updated on JULY 18, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

On : 7.9.6.3 [AN 1900] version, Analytics

OBIEE HR Workforce Profile FTE Fact Incorrect Includes Deleted Assignment

There is an issue with BI Apps subject area 'Human Resources - Workforce Profile'. Values shown for FTE fact show incorrect values.

One particular employee is showing as FTE of 2 where this should be 1.

Facts are retrieved under folder: Facts - Human Resources - Workforce Profile -> Workforce Profile Facts ->
Fact Columns: 'Total FTE' and 'FTE (Employee)'

On investigation, it appears this data is being retrieved from warehouse table 'w_wrkfc_evt_month_f'. The discrepency for the employee in question shows an assignment shown in the table which existed in the source system (e-business suite) for one night before being deleted. This therefore no longer exists in the source system however is still being counted in OBIEE.

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