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'))