FORMULA TYPE Compensation Default and Override is taking long time to execute

FORMULA TYPE Compensation Default and Override is taking long time to execute.

 while loop is executing for all employees while executing for single person.

Requirement is needs to fetch “cell Assignment” value from Talent Ratings of an employee.

Navigation: search for an employee>>Show more>>Talent Ratings>>9 Box Cell Assignment

Current behavior: while loop is executing for all employees while executing for single person.

Exp

ected behavior: while loop should execute for single employee while executing for single person.

--Sample Fast formula code

 

CHANGE_CONTEXTS( PERSON_ID=l_person_id) 

(

  WHILE HRT_PERSON_N_BOX_CELL_ASSIGN_BOX_SEQUENCE.EXISTS(l_index)