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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

How do you make a query that will default a value in the People Group field in Assignment?

edited Sep 15, 2020 9:21AM in Human Capital Management 6 comments

Summary

We have a requirement such that when Job = Job123 and Payroll = Biweekly then default the People Group field to Crew. Is this possible?

Content

Navigation: Go to Manage Key Flexfield > Manage Structure Instances > Query for the flexfield > Click on Edit >Select a segment > Click on Edit > Select Default Type as SQL and write query in Default Value section

I need guidance on how the SQL should be written if the requirement is to set a default value in People Group when a certain Job and Payroll combination is assigned to an individual. 

Many thanks in advance.

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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