Default Values in Qty Ord Hold Oracle Alert
I'm trying to set a default email address in case the Requestor is not provided or if they don't have an email provided. I included a DECODE() function around the Requestors email variable in the SQL and it shows up as input varialbes on both the Action Set message and the Alert Details. Didn't know which one to populate so I put the email address in both. I've tried with single quotes, double quotes, and text without quotes but I can't seem to get it to work. The Alert kicks off but no notification is sent if there isn't an email provided. I see the
Tagged:
0