Hi colleagues,

I have faced with the same requirement a couple of times that has not yet been addressed by standard configuration in Oracle HCM Cloud.
There is an ER filled – System Should Restrict Salary Change if it is out of Grade Range (Doc ID 1625750.1)
Currently the system only fires a warning message but doesn’t prevent submitting a transaction.
I have no idea what prevents Oracle to develop this small enhancement but I would like to suggest a workaround that can resolve the issue.

It is based on the element input validation fast formula we can define for a salary element that is going to be linked to a salary basis as well as a grade rate structure.
Detailed steps you can find here: CASE STUDY: Fusion Fast Formula: How to Create Fast Formula For Element Entry Input Value Validation (Doc ID 1615323.1)

Let me briefly outline the setup steps:
1. Create a Fast Formula. I assume we have only a primary assignment otherwise a formula should be adjusted to support multiple assignments.

DEFAULT_DATA_VALUE FOR PER_ASG_GRADE_RATE_VALUE_MINIMUM is ‘ ‘
DEFAULT_DATA_VALUE FOR PER_ASG_GRADE_RATE_VALUE_MAXIMUM is ‘ ‘

DEFAULT FOR ENTRY_VALUE is 0

INPUTS ARE ENTRY_VALUE

IF (ENTRY_VALUE < to_number(PER_ASG_GRADE_RATE_VALUE_MINIMUM[1]) or ENTRY_VALUE > to_number(PER_ASG_GRADE_RATE_VALUE_MAXIMUM[1])) THEN

(
FORMULA_STATUS = ‘E’
/* FORMULA_MESSAGE = GET_MESG(‘HRX’,’HRX_…’) */
FORMULA_MESSAGE = ‘The amount is invalid, enter an amount between ‘ || PER_ASG_GRADE_RATE_VALUE_MINIMUM[1] || ‘ and ‘ || PER_ASG_GRADE_RATE_VALUE_MAXIMUM[1]
)
ELSE
(

FORMULA_STATUS = ‘S’
)

RETURN FORMULA_STATUS, FORMULA_MESSAGE

2. Create a salary element and assign a FF.

3. Create a salary basis and link it to the salary element and a grade rate

–

4. Try to create a salary that is out of the grade rate range

–

I can admit that the error message is not very friendly but anyway the solution prevents entering incorrect salary amount and we are able to achieve our requirement.

I hope it helps.

Kind regards,
Volodymyr