GP ESP - Bug in Criteria in View GPES_FDI_EE_VW

(Doc ID 2042282.1)

Last updated on NOVEMBER 02, 2015

Applies to:

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

Symptoms


Bug in Criteria in View GPES_FDI_EE_VW

When obtaining FDI notes for Social Security, a wrong criteria in the SQL statement produces a failure consisting on not retrieving the sick-confirmation and sick-end notes with a date higher than a Job Data effective date if this Job Data effective date is higher than the sick-begin date.


The issue can be reproduced at will with the following steps:
1 . Main Menu> Global Payroll & Absence Mgmt > Payee Data > Maintain Absences > Absence Event ESP
Set a new Absence (IT) for a emplid (Date: 17-05-2015).

2. Main Menu> Global Payroll & Absence Mgmt > Payee Data > Maintain Absences > Absence Event ESP > Additional Data
In FDI Data, set a new Sick Note Data (PB) for a emplid (Date: 17-05-2015).

3. Main Menu> Workforce Administration> Job Information> Job Data
In Job Data, set a new Data Change Action for a emplid (Date: 19-05-2015).

4. Main Menu> Global Payroll & Absence Mgmt > Payee Data > Maintain Absences > Absence Event ESP > Additional Data
In FDI Data, set a new Sick Note Data (PC) for a emplid (Date: 24-05-2015).

5. Main Menu> Global Payroll & Absence Mgmt > Social Security/Insurance > Create FDI File ESP
The Sick Note Data (24-05-2015) won’t be retrieved for Social Security report

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