Phone Country Code Getting Saved with Padded 0s in the Database
(Doc ID 2767755.1)
Last updated on APRIL 12, 2021
Applies to:PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.
When a Country Code of 1 is entered in a Phone under Profile tile > Contact Details and saved, querying the database table PS_PERSONAL_PHONE shows
Country Code with 001.
Steps to Reproduce the issue:
- Login as Student
- Click Profile tile
- Go to Contact Details
- Click + sign on the Phone section to add new phone number
- Select a Type
- Enter in a Country Code of 1 and Phone Number of 1234567
- Run the "Select * from PS_PERSONAL_PHONE where EMPLID = <emplid of the
student where phone is added>" in the backend --> Country Code shows 001 and not 1.
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