You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Element Input Validation Fast Formula strange behaviour

Received Response
edited Nov 16, 2021 10:22AM in Compensation 6 comments


Content (required):

Hi Team,

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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!