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.
Name Format definitions into a report
Summary:
Hi
Trying to extract from the Oracle the Name Format definitions into a report. Saw in document 2312477.1 the following explanation:
The Name Formats is stored in FORMAT_MASK column of HR_NAME_FORMATS table. It is in encoded format like |$FIR$$SPA$$COM$||$LAS$|. This is build on some specific internal logic. Customer can refer to "FORMAT_MASK" field, but it doesn't mean anything to them. If they want to decode, they need to replace the 3 letter characters between "$" with the equivalent lookup code value of PER_NAME_FORMAT_COMPONENTS(main name items like first name, last name etc), PER_NAME_SUB_FORMAT_COMPONENTS(for signs like comma, space etc).
Tagged:
0