Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Changing SSN to include dashes
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.
Tagged:
0