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

Last updated on MAY 11, 2017

Applies to:

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

Symptoms

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.
 

ERROR
-----------------------
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)


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

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