My Oracle Support Banner

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:

  1. Login as Student
  2. Click Profile tile
  3. Go to Contact Details
  4. Click + sign on the Phone section to add new phone number
  5. Select a Type
  6. Enter in a Country Code of 1 and Phone Number of 1234567
  7. Save
  8. 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

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