Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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