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
Need to display which candidate filled the last open position of filled requisitions
Summary
We are not able to display which candidate has filled the last open position of filled requisitionsContent
Hi,
We have created below custom formula to display the candidate name who filled the last open position of requisition.
Custom formula:
case when "Requisition Tracking History"."Transaction Event Type" = 'Last Position Accepted' and "Requisition Status - Current"."Current Status" = 'Filled' then "Candidate Identification"."Name" when "Requisition Status - Current"."Current Status" in ('Approved','On Hold','Sourcing') then ' ' end
As per the requirement, Candidate name should only be displayed when requisition status is filled and when that candidate has filled the last open position of requisition. If requisition status is opened or not filled then “Filled By” column should remain blank.
0