You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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.

Seniority Date Fast Formula not updating LOS value

edited Sep 14, 2024 8:45AM in Human Capital Management 1 comment

We have a requirement that there is a DFF in Work Relationship attribute which will be updated for Acquisition Date. When this field is not NULL, the Length of Service will be updated based on this date, or else it will update based on Original Hire Date. The Fast Formula is returning multiple lines and not updating LOS value. Please suggest.

/*FORMULA TYPE: Employment Seniority Date Adjustment*/

DEFAULT FOR PER_REL_DATE_START IS '0001/01/01 00:00:00' (date)
default for BASE_SENIORITY_DATE is '1900/01/01 00:00:00' (DATE)
DEFAULT FOR SENIORITY_ADJUST_IN_DAYS IS 0
DEFAULT FOR PER_ASG_PERSON_ID IS 0

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!