Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Value set table result empty but not the SQL statement
Summary:
Hi All,
In fast formula for compensation, we calling a value set by using GET_VALUE_SET function, but it is not returning any data.
When I execute the SQL statement from the value set, I get some data :
VALUE SET NAME : TEST_VS
Select asg.****_ATTRIBUTE6
From PER_ALL_ASSIGNMENTS_M ASG
Where ASG.ASSIGNMENT_ID = '300000035948702'
AND ASG.assignment_type = 'E'
and asg.person_ID='300000030509268'
AND to_date('2023/12/31','YYYY/MM/DD') between ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE
When I try to test my value set with the following statement, it doesn't work :
Tagged:
0