Work Schedule DBI Absence Formula
I am trying to get work schedule name or shift name in the Accrual Matrix formula. Work schedule is assigned at the assignment level.
Followed information available under - A New DBI Item To Hold The Shift Name Of An Employee (Doc ID 2512452.1)
Followed example under Doc ID 2577042.1. Created Absence validation formula to get the schedule name but instead got below error,
The message is ORA-20001: Formula ****_SCHEDULE_CHECK, line 6, array data value missing. Details: There is no data for array ANC_PUBLISHED_SHIFT_NAME_ARR, index -1. For example, if an array is set up with only two data values at indexes 1 and 3, such as a = -1 a = -3, referencing an index value other than 1 or 3, such as b = a, will raise this error. Correct the formula to ensure that array data exists when referenced. ORA-06512: at "FUSION.FF_EXEC", line 3769 ORA-06512: at "FUSION.FF_EXEC", line 3779 ORA-06512: at "FUSION.FF_EXEC_WRAPPER_PKG", line 141 ORA-06512: at line 2