Report to Identify Pending Workers Conversion and Associated Recruiters

Raesah Kachwala

I am in the process of developing a report that will help us identify all pending workers who have not yet been converted to employees in our HCM system. The goal is to streamline our internal processes to ensure that no pending workers are left unconverted before the start date. There is an additional requirement: the report should also capture and display the recruiter who initially hired the candidate.

The purpose of identifying the associated recruiters is to enable us to reach out to them and prompt them to complete the necessary transaction to convert the pending workers to employees.

Raghavendra Raghunath-Oracle

Hi @Raesah Kachwala These data reside in two different subject areas

1. Create a report with person number, assignment number, assignment start date, assignment type. Have a filter criteria like below Count(Distinct Assignment Number BY person number) = 1 and Assignment Type = 'P'
2. You can pass this person number obtained in step 1 above to the recruiting subject area query as a filter to fetch the details of the candidate and the recruiter

p.s. - If this question is on OTBI, please post it in the respective forum.

Thanks

Raghu

Raesah Kachwala

@Raghavendra Raghunath-Oracle Thank you for your feedback and response. I was able to pull the candidate details but not the recruiter details.

Raghavendra Raghunath-Oracle

Hi @Raesah Kachwala which subject area you using?

Raghu

Raesah Kachwala

Hi @Raghavendra Raghunath-Oracle, I am using the Workforce Management - Worker Assignment Real Time subject area.