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

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

Sample SQL for Native Signatures on Journeys

Summary:

How could I create a query to display the below so they pull into the parameters along with the required information for each RTF? We also want the physical signature ESIGN_SIGNATURE.

Parameters: P_ALLOCATED_TASK_ID , P_ALLOCATED_CHECKLIST_ID ,P_PERSON_ID , P_SIGNER_NAME,P_SIGNER_EMAIL , P_SIGN_DATE , P_SIGNER_ADDRESS

I have two template RTFs to create (require 2 different queries I believe):

  1. Requires: Name, Person Number, Employee Signature, Date
  2. Requires: Name, Social Security Number, Employee Signature, Date


Content (please ensure you mask any confidential information):


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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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