My Oracle Support Banner

EEX9.2: Getting Error Message When Updating Number Field In Employee Update Profile Page (Doc ID 2243808.1)

Last updated on APRIL 21, 2020

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


An error appears when user updates Number field in Employee Update Profile page for NLD country.

1. Use below SQL statement to update employee Profile
update PS_PERS_DATA_EFFDT set NUM1='2A' where emplid='KU0021';
update PS_PERSONAL_DATA set NUM1='2A' where emplid='KU0021';
2. Modify Number from 2A to 2 and click Save

Number should contain Numeric Data. (1000,379)

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps containing the complete configuration and the replication steps necessary to reproduce the issue.


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.