In Peoplesoft whenever Employee hiring date was changed to future data those records not being picked up by the ETL (Doc ID 2242420.1)

Last updated on MARCH 22, 2017

Applies to:

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

Symptoms

 On : 11.1.1.7.151020 version, Analytics

When our HR department updates an employee's future hiring record in PeopleSoft from one month to the next (November to December) the change does not permeate into Datawarehouse, OBIEE still captures previous hire date record and this issue throws off counts on month level reporting.

For e.g. Employee hired on November 28th but later updated to join future hire of December 12th. Noticed in PeopleSoft there is only one hire record in PS_JOB for that employee while on Datawarehouse in W_PSFT_WEVT_JOB_PS table contains both records, the 11/28 and 12/12 records.

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