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.

Unable to create an SQL default for Offer Flex field

edited Mar 1, 2021 8:22PM in Recruiting, Opportunity Marketplace 9 comments

Summary

Error message when trying to associate default value for an Offer flex field

Content

I'm creating an Offer flex field called 'Overtime Status'.

The aim of this field is to fetch the FLSA status from Job associated to the requisition.

On the DFF page, I have set

  • Default Type to 'SQL'
  • Derivation value to 'SUBMISSION_ID'
  • Default Value is the SQL: Select leg.information1 from IRC_REQUISITIONS_B req, IRC_SUBMISSIONS sub, PER_JOB_LEG_F LEG
    where sub.requisition_id=req.requisition_id
    and req.job_id = leg.job_id
    and SYSDATE between leg.Effective_start_date and leg.effective_end_date
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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