Core Workflow - EBS (MOSC)

MOSC Banner

How can a message template subject in WFMAIL be prefixed by SYS_CONTEXT('USERENV', 'DB_NAME') showin

edited Apr 2, 2015 10:36AM in Core Workflow - EBS (MOSC) 2 commentsAnswered ✓

In System: Mailer workflow, I have copied the Workflow Open Mail (Templated) message and created a custom message template by modifying the subject, adding the name of the instance. I have assigned it to the Workflow Notification Mailer and it works as expected.

The request though is that the subject of all e-mail notifications shows the instance it is coming from using SYS_CONTEXT('USERENV', 'DB_NAME'); so it is dynamically determined. If I create an attribute and assign a value to it by calling a PL/SQL procedure using SetItemAttribute, I would have to call that function in a process. I cannot do it in System: Mailer as it contains only templates and I definitely do not want to modify every single workflow that we use or will possibly use to call this function. So the templates seem like the best option; however, I cannot get

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center