How to return array in fast formula
Summary
How to return array in fast formulaContent
I have a requirement to route the approval to a particular role when a Compensation plan is submitted. For example, when a manager has submitted a compensation plan for approval, it should route to all the users assigned to a particular role. I tried achieving it using fast formula but could not successfully do it. Can anyone suggest me how to achieve this.
My Formula:
DEFAULT_DATA_VALUE FOR PER_EXT_PER_USER_ID IS 0
L_PERSON_NUMBER= ' '
I=1
WHILE PER_EXT_PER_USER_ID.EXISTS(I) LOOP
(
l_user_id=to_char(PER_EXT_PER_USER_ID[I])