OBIA 11g HR Workforce Profile FTE Fact Incorrect Includes Deleted Assignment
Last updated on JULY 18, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206 [AN 1900] and later
Information in this document applies to any platform.
On : 220.127.116.11 [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.
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