Can we restrict Job requisitions LOV's input parameters for Job Applicatio Report to Hiring Manager? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Can we restrict Job requisitions LOV's input parameters for Job Applicatio Report to Hiring Manager?

Summary:

Hiring Managers should only be able to run the Job Application report for the Requisitions they are listed as the Hiring Manager whereas Recruiters should have access to run the Job Application report for all job requisitions.

If anyone has faced similar requirement, Can you please provide your comments?

Currently we are restricting the List of values available for selection by making changes at Data model level.

List of values

Query for REQ(Requisition Name):

select distinct

TITLE 

from

IRC_REQUISITIONS_VL

where 1=1

and OBJECT_STATUS = 'ORA_ACTIVE'

and (RECRUITER_ID = (select distinct person_id from per_users where user_guid = FND_GLOBAL.user_guid) or

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!