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

Last updated on MARCH 14, 2017

Applies to:

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

Symptoms

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

Steps
1. Use below SQL statement to update KU0021 Jessica Bendetto 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

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

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