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

    SQL Sample Query for Native Electronic Signature

    in Human Capital Management 13 comments

    I am looking for help on modifying the SQL query I'm using in a data model for the native electronic signature task type. I'm looking to add a parameter for job title and enterprise hire date so it can be incorporated in a RTF template. The Oracle guide I found didn't have much resources on this.

    Version (include the version you are using, if applicable):

    23A

    Code Snippet (add any code snippets that support your topic, if applicable):

    SELECT DISTINCT Person.PERSON_ID

    ,PAT.ALLOCATED_CHECKLIST_ID AS P_ALLOCATED_CHECKLIST_ID

    --,PAT.ALLOCATED_TASK_ID AS TASK_ID

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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