Campus Solutions - PSFT (MOSC)

MOSC Banner

Phone Number from SAT Load Not Saving in PeopleSoft Default Format

edited Dec 20, 2016 4:03AM in Campus Solutions - PSFT (MOSC) 2 commentsAnswered

I'm working through an issue with phone numbers that we are bringing in via our SAT load through File Parser.  The file parser mapping is set up to bring in phone numbers direct from file.  At some point, either at staging or when being inserted into PS_PERSONAL_PHONE, I would expect the phone number to be saved in the database in the PeopleSoft format (555/555-5555), but the numbers are saved only as ten digits without any special characters.

After navigating to Add/Update a person, the phone number appears to be formatted correctly.  After saving the record, the phone number is updated in the PS_PERSONAL_PHONE record with the correct formatting.  In order to fix this we currently have to open each record one by one and save or sql update the numbers.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center