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
1
Views
6
Comments
edited Nov 16, 2021 10:22AM in Compensation 6 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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