Workflow Notification Template
All the workflow notifications follow a certain template, which means you see a Header Level Region indicating To Role, From Role etc.
In the centre you have the notification body and at the bottom you have response section.
Sometimes your requirement is to change this formatting/structure of the workflow notification. Also, in some other cases, you might wish to hide one of the sections in the Workflow notification. In this article you will learn the basic principles of how Oracle Workflow formats its notification by using template.
What is a notification template?
Every Oracle Apps instance has a workflow named "System: Mailer", with its item type name being WFMAIL
This workflow can be opened using the Workflow Builder tool.
How does this workflow control the formatting of notifications?
This workflow has various messages that correspond to different types of notifications, for example FYI notifications etc.
The workflow notification engine reads the structure of "notification template" before building the notification contents.
Give me some examples of this Notification Template?
For example, FYI Notification uses template as shown below
I wish to modify this template to meet my business requirement. Can I do so?
In theory you can modify this code template, but this is not recommended, as Oracle my release patches to modify this template in future.
Without modifying this template, how can I meet my business requirement?
You can do so by doing steps below
Create an altogether new template
Specify this new template by overriding a specific notification, example "PO Approval Notification"
The approach listed above is safer and also allows you to override the notification structure/format for individual notifications.
We will see these steps in a later article.
Apps2Fusion Articles 
Comments
Can you please explain this line. It was not clear how to override the original template ? Can you provide screenshots as well.
Create a custom version of the Standard System Mailer Workflow
Open the System: Mailer
Save it as XXSYSML
Open its wft in textpad and search and repace WFMAIL by XXSYSML
Now open this XXSYSML.wft file and change the Name of Workflow from "System: Mailer" to "XX System: Mailer"
Now you can modify the templates within this workflow as desired.
Now, go back to your PO Approval Workflow and attach a new attribute of name for FYI, #WFM_OPEN_MAIL_FYI
Make the value of this attribute point to custom version of "System: Mailer" template
Th anks,
Anil
fadi
I am in the need of modification of sourcing notifications. Plase guide me how to do this. As i searched wft files there are around 13 wft files for sourcing workflow.
I have to to like...
1. changes in the message when supplier responses/creat e quote to rfi/rfq
2. online discussion to send as message
This article is about a concept, I am yet to use it on system.
If someone implements this, then write your experience here.
Cheers
A nil
What is the subject of the notification which users are seeing?
Based on that text, query wf_notification s table searching for subject column,
From that table, you will find the notification id and the corresponding message that you need to customize.
Tha nks,
Anil
1. Create a copy of the notification you want to modify like xxx_Approval Notification
2. Make your changes
3.Save the workflow in the database (Use workflow defination loader)
4.Goto OAM and replace the standard approval notfication with the custom one
You cannot change the template for a particular notification. If you are modifying the FYI template, then the changes will be reflected in all times of FYI notification.
If anyone need any more information, please let me know..
cheers
Pillai
Always been a big fan of your site. I had a quest regarding the WF Notifications. Suppose I want to suppress ALL HR messages (having an HR_ prefix) to from showing sensitive data via email? I am able to successfully suppress certain message and add a custom attribute and point it using #WFM_OPEN_MAIL and #WFM_OPEN_MAIL_ FYI to a custom template I created (I copied the corresponding message into a new WF Item from System:Mailer and edited the HTML body). However, is there a way to route ALL HR messages from going through my custom template? In particular, my questions are:
1) Is there a way to determine exactly which System:Mailer templates correspond to each HR message? I see that some are Action Required and others are definitely FYI..whereas others are Closed..etc. I am able to guess which it is but is there a more definitive way to check?
2) How can I get ALL HR messages to ensure that they go through my custom templates? My thought was that I copy ALL the System:Mailer templates into my custom WF item, and then add an attribute in ALL HR messages (progrmatically ) for every available type of routing (#WFM_OPEN_MAIL , #WFM_CLOSED, #WFM_OPEN_FYI.. etc etc). Can this approach work? Is there a simpler way to do it?
Thanks in advance and thanks for your continued efforts.
Ahsan
Interest ing question
It appears that you wish to override the template at Application Level[HR].
Unfo rtunately, you can only override the template at individual WF message level or at site level.
Hence, there is no straightforward way to achieve what you want.
Unsupport ed route of course is that you insert records into table WF_MESSAGE_ATTR IBUTES for all the messages that begin with HR and provided their item types too belong to HRMS Workflows
Than ks,
Anil Passi
Thanks for ur wonderful knowledge sharing articles. It has been very helpful in both OAF n Workflow.
I have a small request. I need to FYA notifications to a Manager group which are set up in jtf_rs_groups_v l table. I need to fetch all the members in this group and send FYA notifications. How can i send the notifications to all of them in one shot? Can i put them in a role and set the role as performer? Please help me.
Regards,
N orman.
You can create ad hoc role and add as many users you wish to that role.
Use api wf_directory.Ad dUsersToAdHocRo le
When you send notif to this role, each user in that role will also receive that notification
T hanks
Anil Passi
Thanks for the Help. It is working fine now.
There is one doubt. When I am sending the notification to all the members in the role, with expand role check flag is checked, Individual notificaiton will be sent to all. Suppose 3 users present in the role, Notification_ID 111 goes to user1, 112 to user2 and 113 to user3 But in wf_item_activit y_statuses only Notification_ID 111 will be stored. Even if the user2 has responded to the notification, in wf_item_activit y_statuses table, corresonding record is updated with Notification_ID 111 and the comments that the responder has put will be stored in wf_notification _attributes table for the WF_NOTE attribute. My question is, I wanna know who has responded to the notification which i can get in wf_comments table but it is not in sync with the notification_id which is present in wf_item_activit y_statuses table. is there any join between these?? How can i find the exact responder corresponding to the record present in wf_item_activit y_statuses and wf_notification s table??
Please Help me.
Thanks in Advance.
Norman
I am in the need of text changes in Oracle Sourcing Notifications as...
1. submission of Request (RFI/RFQ) : when supplier submits a response or quote, new email has to go to buyer and the approver
with changed text.
2. Removal of Receipt of supplier acknowledment notification.
3 . New notifications to advise supplier and buyer of any discussion raised (for Online Discussion).
P lease let me know how to achieve these points.
One more !
I Customised the package used in get_check_info function in APPEWF wf
to send the FYI : AP Remittance Advice Notification. Earlier it was working fine. Now the wf is stucking with the error message
must be declared.
Plea se advise how to resolve this.
Thanks n Regards
Kirti
I' m new to oracle what is AME & workflow??can anyone guide me what is that i'm so confused...
th anks in advance
In the last approver notification page, client wants to have an option whereby they select from a LOV FYI notifiers they want to specify.
How can i achieve this?
Thanks to provide some insight into that.
Navin
Client wants to add the Voucher number should be displayed in the Invoice approval notification in the subject line and body.
Can you please guide me how to accomplish this task.
Thanks/
Jagadi sh
Can you please confirm if the change proposed will only change the email notification and retain the original approval format in the worklist.
The client requirement here is to notify the user with a simple email saying "You have a notification to approve", the next step being the user logging into EBS and approving via the worklist.
Thank s
Ed
Pleas e if you still want add the Voucher number should be displayed in the Invoice approval notification in the subject and body,please contact with me thru my eamil and will send you the steps
Best reagrds,
Mohamm ed Rizk
I need to turn off one FYI notification (OTA_LNR_ENROLL _STS_NTF_NO) in Oracle Workflow Builder.
How to do this?
Regards,
Iva
We have a Oracle workflow email which has header with the information(sta ndard) sent,date and ID(which is notification ID).We have a requirement to change the date format and remove the notification ID from header.I would like to know how can I change the standard template and where can I find the mapped header .Please let me know.We are struggling with this from long time.
I have a requirements to "extend" the template of PO Approval Notification in 11i. I need to modify the worklist template, not the one sent by email.
I added the additional attributes to the PO Approval workflow, I am missing the info/example of how to modify the Notification HTML Page created
I need to develop a Workflow with Line Level Action Responses. Is it possible at the first place? If yes then how. Please help me with an example.
Thank You,
Amit Mitra
Need help on the below scenario,
Supervisor can initiate leave on behalf of employee
Requirement:
After the final approve/reject of LOA (Absence) FYI Notification should send to employee.
Current setup is Notification is sending to initiator after approve/reject of an employee leave.
I created one rule of category FYI. added pre chain and post chain of approval group to the rule.
So Once the supervisor submit leave request on behalf of employee,
employee is getting FYI notification that request forward to managers approval. (Initiator is getting notification as per standard)
Once the manager approves, employee is getting FYI Notification that leave request got approved, (Initiator is getting notification as per standard)
But Once the manager REJECT, employee is NOT getting any FYI Notification at all. (Initiator is getting notification as per standard)
Only rejected transaction FYI Notification is not getting by employee.
Please advise if any thing i can do.
Need help on the below scenario,
Supervisor can initiate leave on behalf of employee
Requirement:
After the final approve/reject of LOA (Absence) FYI Notification should send to employee.
Current setup is Notification is sending to initiator after approve/reject of an employee leave.
I created one rule of category FYI. added pre chain and post chain of approval group to the rule.
So Once the supervisor submit leave request on behalf of employee,
employee is getting FYI notification that request forward to managers approval. (Initiator is getting notification as per standard)
Once the manager approves, employee is getting FYI Notification that leave request got approved, (Initiator is getting notification as per standard)
But Once the manager REJECT, employee is NOT getting any FYI Notification at all. (Initiator is getting notification as per standard)
Only rejected transaction FYI Notification is not getting by employee.
Please advise if any thing i can do.
RSS feed for comments to this post