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) or ENTRY_VALUE > to_number(PER_ASG_GRADE_RATE_VALUE_MAXIMUM)) 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 || ‘ and ‘ || PER_ASG_GRADE_RATE_VALUE_MAXIMUM
FORMULA_STATUS = ‘S’
RETURN FORMULA_STATUS, FORMULA_MESSAGE
2. Create a salary element and assign a FF.
I hope it helps.