Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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.
Tagged:
0