Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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