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
Automatically Unpost Job Requisition after the positions are filled using fast formula
Summary:
Need to unpost Job Requisition after positions are filled. Created a fast formula and trying to get count of requisition_id but cannot able to use count condition in Value set. Please help
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
DEFAULT FOR IRC_REQ_REQUISITION_NUMBER IS 'NA'
CONDITION_RESULT = 'N'
REQ_COUNT=0
COUNT = COUNT_JOBAPPS_ACTIVE_IN_PHASE_STATE(IRC_REQ_REQUISITION_NUMBER, 'Offer', 'Accepted', 'US')
REQ_ID = GET_CONTEXT(IRC_JOB_REQUISITION_ID,1)
IF (REQ_ID > 1) THEN
0