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.
query picking up blank submit and missing the dependent amt changes in benefits life event
1- we have 2 different queries written for Open Enrollments and New Hire, Unrestricted & Other Life events .
2- we want employee records to be pulled when employee finally clicks "submit" on their life events .
3- we want to consider records when employee has changed their benefits amount for the respective life event and 4- code should also pick up record when employee changes only the percentages of the amount divided among them and their dependents/beneficiary .
5-we want to reject blank submits
6- kindly help us with SQL queries or help us to identify columns and tables which gets populated with certain values on these events .
0