In Peoplesoft whenever Employee hiring date was changed to future data those records not being picked up by the ETL
Last updated on MARCH 22, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206 and later
Information in this document applies to any platform.
On : 220.127.116.11.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.
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