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.
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