Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 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.

How to use Value Sets like JobFamilyPVO in content types on the profile

edited Sep 4, 2018 8:41PM in Career and Succession 1 comment

Summary

We need help creating and using a value set, similar to how the delivered Career Preferences Content Type use JobFamilyPVO.

Content

We are setting up Career Development, and one of the asks is that a user can identify specific jobs of interests based on a list of all active job codes in the system. I notice that The "Career Preferences" content Item makes use already of a few different value sets. For example, JobFamilyPVO gives a list of the job families. 

I'm trying to replicate that by either creating my own custom value set that does a sql lookup against the PER_JOBS view or PER_JOBS_F table but I'm failing. (I was suprised to find that All Jobs isn't an existing lookup, but I could be wrong as the search UI is really hard to use as it won't let me start my search with a wildcard)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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