My Oracle Support Banner

How To Use Seniority Formula In Grade Step Progression? (Doc ID 2476834.1)

Last updated on JANUARY 28, 2020

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version and later
Information in this document applies to any platform.


A fast formula needs to be used in eligibility profiles for progression grade ladder step rules. This formula is supposed to look at the date that someone entered the grade step they are currently in and once they have been in that step for 6 months, they are eligible to move into the next step. We tested this formula in a test progression grade ladder containing one grade with 4 steps. 

After hiring an employee as of 2/5/2018 (over 6 months ago) and then ran the 'Run Grade Step Progression' process. After running the process, Review Proposed Progressions and Salary Updates task to approve the progression and there was an error saying the employee was not eligible for the next step in the grade ladder. The formula appears to be correct.

The formula uses the PER_ASG_STEP_ENTRY_DATE DBI.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.