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

Default EFF segment based on prior entry

edited May 11, 2021 11:11AM in Human Capital Management 1 comment

Summary

We are looking to use custom SQL to create a default for an EFF segment

Content

We have the requirement to produce a default when a prior date is entered into a segment of the EFF. The requirement is to add 6 years onto the start date which is entered by the user. The following is the SQL that has been used to try and achieve this: select add_months(:{SEGMENT.XX_HCM_POST_START}:, 72) from dual

Where XX_HCM_POST_START is a segment defined in the EFF structure. This produces an error when entering information into the EFF.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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