You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Work Schedule DBI Absence Formula

Received Response
edited Aug 26, 2020 5:05PM in Workforce Management 2 comments


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] = -1 a[3] = -3, referencing an index value other than 1 or 3, such as b = a[2], 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 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!