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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Query to find Ownership type of candidate pool(Private, Shared, Global)

in Reporting and Analytics for HCM 3 comments

Summary:

I need to show ownership type(Private, Shared, Global) of Candidate Pool in BI report. I am unable to find any table that stores this information. However, there is a lookup 'ORA_IRC_POOL_STATUS' which has these 3 values in lookup meaning. But, I cant find any column in candidate pool related tables or views like hrt_pools_b, irc_pools_v etc so that I can join that column with this lookup to get the actual values.

Please let me know if there is any table which I can use.


Thanks and Regards

Sujay


Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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