Unable to create an SQL default for Offer Flex field

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