Unable to create an SQL default for Offer Flex field
SummaryError 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
and req.job_id = leg.job_id
and SYSDATE between leg.Effective_start_date and leg.effective_end_date