GPESP: Payslip ESP Error For An Employee With More Than 9 Segments In Retro Month
(Doc ID 2641009.1)
Last updated on MARCH 09, 2020
Applies to:PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.2 and later
Information in this document applies to any platform.
When generating the calendar of retroactivities of employees that have many segments (field rslt_seg_num of table PS_GP_PYE_SEG_STAT greater than 9), an SQL error occurs in the SQR gpespys1.sqr used for Payslip ESP.
/peoplesoft/oracle/pshcm92/sqr/gpespys1.sqr: - SQL Statement =
SQL Status = 936, SQL Error = ORA-00936: missing expression
Error on line 71:
(SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.
The issue can be reproduced at will with the following steps:
1. Use an employee with many segments (grater than 9)
2. Calculate retroactive for this employee
3. Generate Payslip ESP
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