How to restrict users to enter a salary amount outside a grade range

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

One thought on “How to restrict users to enter a salary amount outside a grade range

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.