Extract run Failing after adding new FastFormula
Summary:
Extract is failing after adding new rule to get the correct parking tier based upon employee salary
Content (please ensure you mask any confidential information):
I have added a new rule to the extract, that is assigning parking tiers to employees based upon their salary and job title. But the extract run is giving me error saying:
Token1 ORA-20001: Formula CRUNV_GET_SALARY_INFO, line 26, array data value missing. Details: There is no data for array DATA_ELEMENTS, index asg_salary_amount. 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.