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
To unpost a requsition created a fast formula but issue with value set not returning any value
Summary:
If i run the value set query it working fine but if in include in Fast formula i think it was not returning any value. Checked using the function
SELECT pay_ff_functions.gvs ('Requisition_Unpost_VS','|=P_REQUISITION_ID=300000265383490') value FROM dual
Fast formula:
CONDITION_RESULT = 'N'
REQ_COUNT=0
REQ_ID = GET_CONTEXT(IRC_JOB_REQUISITION_ID,1)
IF (REQ_ID > 1) THEN
(
REQ_COUNT = to_number (GET_VALUE_SET ('Requisition_Unpost_VS','|=P_REQUISITION_ID='''||to_char(REQ_ID)||''''))
IF (to_number (REQ_COUNT) > 0) THEN
(
CONDITION_RESULT = 'Y'
)
)
RETURN CONDITION_RESULT
Value set:
selectirv.NUMBER_TO_HIRE
Tagged:
0