My Oracle Support Banner

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.

Symptoms

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.

ERROR
-----------------------
/peoplesoft/oracle/pshcm92/sqr/gpespys1.sqr: - SQL Statement =
GPESPYS1.SQR,Get-Line-Earning-Retro,Select,PS_GP_RSLT_DELTA
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.


STEPS
-----------------------
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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.