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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

Alert Composer is printing pending worker details in the email msg template for projected end date

Summary:

Hi Team,

We are using custom Alert composer to print projected end date. When employee projected end is sysdate+28 days, we are sending alert notifications to line manager. But the challenge here, it is printing both pending worker details & Employee details in the table. How do we restrict pending worker details printing in the table?

Content (required):

we are using the below groovy code to print the values.

${AlertUtils.write("<table border=\"1\"><tr><th>Name</th><th>Person Number</th><th>Assignment Number</th><th>Assignment Projected End Date</th></tr>")}${AlertUtils.loop('emps,assignments','','<tr><td>${emps.DisplayName} </td><td>${emps.PersonNumber} </td><td>${AssignmentNumber}</td><td>${AlertUtils.formatDate(AssignmentProjectedEndDate[0],\'dd-MMM-yyyy\')} </td></tr>')}${AlertUtils.write("</table>")}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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