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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Requisition DFF - Default Values or parameters for Table Validated Value Set SQL

    edited Jan 7, 2021 5:39AM in Recruiting, Opportunity Marketplace 2 comments

    Summary

    Option to pass parameters/variable from the Requisition UI to auto-populate the Requisition DFF

    Content

    1 - Are there parameters available on the Requisition UI to be used to default the values on the Requisition DFF segments?

    The Job Offer Flexfields now have the feature to get the default value through SQL.  These two parameters are available to create an SQL query or Parameter query:
    ◦ SUBMISSION_ID, which refers to the job application and thus to the requisition
    ◦ PERSON_ID, which refers to the candidate who will be the offer recipient

    2 - If defaulting is not possible, we are considering having a table validated value set attached to the DFF segment. Are there parameters available which can be passed from the Requisition UI to the DFF to be used an input parameters for the Table Validated Value Set ? e.g. Hiring_Manager_Id

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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