Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Element Input Validation Fast Formula strange behaviour
Summary:
Content (required):
Hi Team,
I wrote this formula that works with element input values.
In the element we have 2 input values:
Percentage
Amount
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
0