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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Changing SSN to include dashes

Accepted answer
22
Views
5
Comments
edited Dec 13, 2022 7:12AM in Taleo Enterprise 5 comments

Summary:

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.

Register

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