My Oracle Support Banner

The Headcounts Of Employees Are Dropping As the SNAPSHOT Records Are Not Generated. (Doc ID 2740979.1)

Last updated on JANUARY 05, 2021

Applies to:

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

Symptoms

The headcounts of employees are dropping as the SNAPSHOT records are not generated in the W_WRKFC_EVT_MONTH_F table.

Environment Details:

OBIA 11.1.1.10.2
Oracle HCM Cloud Application 20A (11.13.20.01.0)
HR Analytics (Workforce, Talent, Success Planning, Recruitment)

Changes

The snapshot data for any employee is populated for 6 months during the initial full load or from the last change event (e.g Salary change, Grate rate change etc)
During incremental load the snapshot data is populated for the +1 month during the month start date.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.