My Oracle Support Banner

GP: SEPA - Value Too Large For Column "HRSYS"."PS_GP_PAYMENT_FG"."NAME1" (Doc ID 2264831.1)

Last updated on MARCH 09, 2020

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 and later
Information in this document applies to any platform.


It seems the structure of PS_GP_PAYMENT_FG table has changed with bundles installation (HCM MP9), NAME1 field is new in this record and its length is 40.
In GP_PMT_PREP application engine, there is an step where it is executed an INSERT-SELECT sql where try to insert in NAME1 the value of field NAME (length 50) from PS_PERSON_NAME table, as the length of this field is 50, we get an error when the NAME is greater than 40.

SQL error. Function: SQLExec
Error Position: 5144
Return: 12899 - ORA-12899: value too large for column "HRSYS"."PS_GP_PAYMENT_FG"."NAME1" (actual: 43, maximum: 40)

The issue can be reproduced at will with the following steps:
1. Navigate to Set Up HRMS-> Product Related-> Global Payroll & Absence Mgmt-> Payment Processing-> Run Payment Prep Process
2. Run the process
3. Get the error


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

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