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.
Table type value set Select & From Clause Limitation
Summary:
Need help on Table type value set Select & From Clause Limitations
Content (required):
Hi,
We have a Requirement to Create Table type Value set to display Employee & Contact name based ON certain condition.
we have to Validate so many Conditions to display Weather 'Eligible' OR 'Ineligible' in Select Clause level.
Ex: Employee Name - Eligible
Contact name - Eligible OR Ineligible
Conditions:
Contact Type - Spouse
if more than one Spouse Oldest one to be consider as Eligible Remaining one is Ineligible
Contact Type = Child
1.Age between 3 to 18
2. Eldest to youngest first 3 child are Eligible
Remaining are Ineligible Also not between 3 to 18 also Ineligible
0