SPECIAL_CEILING_STEP_ID is not getting populated in the assignment table

Hi,

We have a fast formula in the extract, and the SQL query is:

SELECT * FROM PER_ALL_ASSIGNMENTS_M WHERE SPECIAL_CEILING_STEP_ID is not null
AND ASSIGNMENT_NUMBER LIKE ('EXXXX%')

For some reasons in another environment, SPECIAL_CEILING_STEP_ID is not getting populated in the assignment table even though the employee has a grade step in his current record and there exists a ceiling step for that grade.

We are using: Assignment Special Ceiling Step Name DBI in the extract to fetch the ceiling step name, also we are using PER_ASG_SPECIAL_CEILING_STEP_NAME DBI in Fast Formula. This values are coming as null.