Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Changing SSN to include dashes — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Changing SSN to include dashes

Accepted answer


Sorry, me again. When it rains it pours.

Currently in Taleo our SSN is stored in ######### format. We do not have any type of data feed to our HCMS because, well we don't have an HCMS, just a payroll system that can't take a feed from Taleo. So, we are using an export from OBI to put new hires into the Payroll system and they want SSN with the dashes in it.

Is there an OBI formula I can use to insert the dashes? I've tried some of the mySQL examples I have found online and most of them don't work in OBI as it says the administrator has not allowed that command. So it should be 123-45-6789 instead of 123456789.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!