GP ESP FDI Selection Doesn't Work When JOB EFFDT > ABSENCE BGN DT (Doc ID 2069752.1)

Last updated on OCTOBER 27, 2015

Applies to:

PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


When an employee was off work and we need to sent to different places the confirmation order creating the file FDI(Esp), there are data that is not returned by the page and it's not possible to create the FDI files
In the sql of the view GPES_FDI_EE_VW when try to join the absences tables (GP_ABS_EVENT and GPES_ABSEVT_NT) with the JOB data (JOB) if an employee has a posterior date to the initial date off work lost all the data if the date (GP_ABSEVT_NT.GPES_SICK_DATE) it's upper to the job data
The issue can be reproduced at will with the following steps:
1. Add an IT absence from 08.05.2015 to 14.07.2015
2. Check Additional Data - Sick Note data from Main Menu > Global Payroll@Absence Mgmt > Payee Data > Maintain Absences > Absence Event ESP and it has two parts of confirmation not yet sent by FDI to date 06/08/2015 and 06/15/2015.
3. Try to generate FDI file for June and the employee doesn't appear.


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