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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Time and Labor Alert Composer Alert not triggering correctly

Summary:

I have created a custom resource alert. The resource is timeRecordGroups. When I test the alert in simulation mode, it sends more alerts than I'm expecting it to.

Content (required):

I've added two filters. One is custom SQL, see snippet below, to trigger based on personId that meet the SQL criteria. The second filter is a person ID that I have hard coded. When I run the SQL in the DB, it returns 1 row.

I've added a simple template, see screenshot below, and am sending the email to my personal address.

I expect the alert to send me one email with the DisplayName that belongs to the person Id I hard coded. Instead it sends over 50 emails. Sometimes the DisplayName is blank, sometimes the displayname is the correct person, and sometimes it's the name of a different person. Why is it sending multiple emails?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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