OBI Applications 7.9.6.3 W_WRKFC_EVT_F Table Not Creating Monthly Snapshot Records For All Employees (Doc ID 1962695.1)

Last updated on JANUARY 31, 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

OBI Applications 7.9.6.3.

Users reported a problem with a report where the number of employees had dropped from 1787 in November to 980 in December.  Upon investigation, it can be seen that the W_WRKFC_EVT_F table is missing snapshot records for the majority of employees.

Count of snapshot records per event_month_wid for change_event_type pf SNAPSHOT:


Month     Count


201408   1937
201409   1917
201410   1906
201411   1811
201412   984
201501   845
201502   751
201503   625
201504   498
201505   399
201506   252


This is affecting user reporting.

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