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.
Pull UDF values into HCM Extracts using FF
Summary
Need to pull UDT values through extract using fast formula (GET_TABLE_VALUE)Content
Hi,
Below are the User-defined Table details created in HCM Cloud.
UDT Name: WORK_COMP_CODE
Columns: Stores all 50 US States
Rows: All active job codes
Worker Comp codes are based on the combination of the two, for eg, CA/JOB_1234 = '8742' and so on. This is FF is added as an Extract rule based FF as shown below in a separate block.
The FF looks like below (FF Type : Extract Rule)
DEFAULT FOR PER_ASG_JOB_CODE IS ''
DEFAULT_DATA_VALUE FOR PER_ASG_LOCATION_ADD_USAGE_REGION2 IS ''
0