Get Started with Redwood for Oracle Cloud HCM Begin Now
Default EFF segment based on prior entry
Summary
We are looking to use custom SQL to create a default for an EFF segmentContent
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:
1