OBIA 11g: Unable to Find an Employee records in W_WRKFC_EVT_MONTH_F,W_WRKFC_EVT_MERGE_F and W_WRKFC_EVT_AGE_F (Doc ID 2273341.1)

Last updated on JUNE 06, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

Not able to view an employee in OBIEE. This employee (along with others) was (were) active.

Employee 'XXXXXX': Unable to find his records in
W_WRKFC_EVT_MONTH_F,W_WRKFC_EVT_MERGE_F and W_WRKFC_EVT_AGE_F.
Have this employee records in W_WRKFC_EVT_F. After investigation found that a filter in W_WRKFC_EVT_AGE_F is restricting this employee records when the termination date event is happening after initial extract date.

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