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 with Redwood for Oracle Cloud HCM   Begin Now

How to access DOR values and display it in Alert Template

edited May 30, 2023 2:09AM in HCM REST APIs 1 comment

Summary: How to get the value from the table HR_DOCUMENTS_OF_RECORD to the Template


Content (required):

We have Document of Record DFF which is a Date Value and is stored in column DEI_ATTRIBUTE_DATE2 from the table HR_DOCUMENTS_OF_RECORD. How to get that value and display it in the Alert Template. See below Screen Shot of our Templa.


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

23A

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

Hello ${AlertUtils.toString(AlertUtils.empManagerList(workers.PersonId).DisplayName)}, 

The Above Level Allowance and/or Delegation for ${AlertUtils.toString(workers.names.DisplayName)} is due to expire on <Expiry Date>. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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