Restriction on transactions prior to the latest job change

Hi Team,

When managers or HRBPs attempt to submit a transaction request with an effective date that is earlier than the latest job change, the system will prevent the transaction from being initiated and display an error message.

The error message will indicate that a future-dated record already exists effective xx-xx-xxxx, and the transaction can only be submitted with an effective date that is on or after the existing future-dated record's effective date.

Could you please advise on the approach to implement this requirement?

Regards,

Swetha M