Seniority date

Summary:

Hi all, I’m currently working on a requirement to adjust the Enterprise Seniority Date in Oracle Fusion HCM based on employee absence history, and I’ve run into an issue where the adjustment formula doesn’t seem to trigger at all.

The business requirement is fairly straightforward. We need to calculate the total number of absence days (for example, prolonged illness or unpaid leave) and deduct those days from the employee’s seniority. So if an employee has, say, 153 days of such absences, the seniority date should be pushed forward by 153 days. To achieve this, I created a Value Set (XX_SG_PI) which correctly returns the required number of days.