Get Started with Redwood for Oracle Cloud HCM Begin Now
Fast formula written error like "There is no data for array DATA_ELEMENTS"
Summary
HCM extract, based on rule written the assignment change flag.Content
Hi ALL,
Below fast formula written the error like
ORA-20001: Formula XX_ASG_CHANGE_FLAG, line 14, array data value missing. Details: There is no data for array DATA_ELEMENTS, index Hire_Date. For example, if an array is set up with only two data values at indexes 1 and 3, such as a[1] = -
Formula
++++++++++
DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT
DEFAULT FOR PARAMS IS EMPTY_TEXT_TEXT
INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)
, PARAMS (TEXT_TEXT)
l_effective_date = trunc(TO_DATE(substr(params['effective_date'], 1, 10), 'YYYY/MM/DD'))
0