Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Element Input Validation Fast Formula strange behaviour — Cloud Customer Connect
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!