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

Unable to create an SQL default for Offer Flex field

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


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


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

Howdy, Stranger!

Log In

To view full details, sign in.


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