Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Unable to create an SQL default for Offer Flex field — Cloud Customer Connect
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
46
Views
7
Comments
edited Mar 1, 2021 8:22PM in Recruiting, Opportunity Marketplace 7 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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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