Element Input Validation Fast Formula strange behaviour
I wrote this formula that works with element input values.
In the element we have 2 input values:
The expected behaviour should be this one:
When Amount =0
Than Amount should be calculated as (Employee Salary*(Percentage/100))
else if The percentage is 0
The percentage should be calculated as (Amount/Salary)*100
The strange behaviour occurs in the case that I wrote amount first and leave blank percentage:
ORA-20001: The data type TEXT of parameter PERCENTAGE doesn't match the data type NUMBER used in the formula.
ORA-06512: at "FUSION.HR_UTILITY", line 798 ORA-06512: at "FUSION.FF_EXEC_WRAPPER_PKG", line 81 ORA-06512: at line 2