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
Another example as below, shows response type notification as visible in OutLook Express
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.
Comments
(22)
Subscribe to this comment's feed
How to modify the template by overriding ?
written by Debojyoty Sadhukhan , August 01, 2008
Votes: +1
written by Debojyoty Sadhukhan , August 01, 2008
...
written by Anil Passi , August 01, 2008
written by Anil Passi , August 01, 2008
Hi Deb
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
Thanks,
Anil
Votes: +2
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
Thanks,
Anil
report abuse
vote down
vote up
good post1
written by fadi hasweh1 , August 01, 2008
written by fadi hasweh1 , August 01, 2008
good post anil, keep them coming
fadi
Votes: +0
fadi
report abuse
vote down
vote up
oracle sourcing notifications
written by kirti , August 01, 2008
written by kirti , August 01, 2008
Hi,
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/create quote to rfi/rfq
2. online discussion to send as message
Votes: +1
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/create quote to rfi/rfq
2. online discussion to send as message
report abuse
vote down
vote up
Customizing Template Notification
written by Linesh PIllai , August 02, 2008
written by Linesh PIllai , August 02, 2008
If you modify the template directly, oracle wont support any issues pertaining to workflow notification. The best way to do is
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
Votes: +0
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
report abuse
vote down
vote up
...
written by Ahsan Shah , August 05, 2008
written by Ahsan Shah , August 05, 2008
Hi Anil,
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
Votes: +0
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
report abuse
vote down
vote up
Sending Notification to Multiple People (HTML)
written by Norman , August 08, 2008
written by Norman , August 08, 2008
Hi Anil
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_vl 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,
Norman.
Votes: +1
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_vl 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,
Norman.
report abuse
vote down
vote up
...
written by Norman , August 20, 2008
written by Norman , August 20, 2008
Hi Anil
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_activity_statuses only Notification_ID 111 will be stored. Even if the user2 has responded to the notification, in wf_item_activity_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_activity_statuses table. is there any join between these?? How can i find the exact responder corresponding to the record present in wf_item_activity_statuses and wf_notifications table??
Please Help me.
Thanks in Advance.
Norman
Votes: +0
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_activity_statuses only Notification_ID 111 will be stored. Even if the user2 has responded to the notification, in wf_item_activity_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_activity_statuses table. is there any join between these?? How can i find the exact responder corresponding to the record present in wf_item_activity_statuses and wf_notifications table??
Please Help me.
Thanks in Advance.
Norman
report abuse
vote down
vote up
...
written by Norman , August 20, 2008
written by Norman , August 20, 2008
Also When i am not checked the expand roles flag, though the notification is sent to everyone, Even if i respond to it, the workflow gets hanged at that notification node. Can u tell me what exactly happening at this node? The notifications are sent as MAILHTML and the notification performers are set using AdHoc Roles.
Votes: +1
report abuse
vote down
vote up
Changes to Sourcing Notifications
written by Kirti Kumar Gupta , August 24, 2008
written by Kirti Kumar Gupta , August 24, 2008
Hi,
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).
Please let me know how to achieve these points.
Votes: +0
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).
Please let me know how to achieve these points.
report abuse
vote down
vote up
Remittance Advice Notifications are not being mailed out
written by Kirti Kumar Gupta , August 24, 2008
written by Kirti Kumar Gupta , August 24, 2008
Hi Anil,
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.
Please advise how to resolve this.
Thanks n Regards
Kirti
Votes: +0
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.
Please advise how to resolve this.
Thanks n Regards
Kirti
report abuse
vote down
vote up
Need urgent help
written by kiranp9949 , December 25, 2009
written by kiranp9949 , December 25, 2009
Hi guys,
I' m new to oracle what is AME & workflow??can anyone guide me what is that i'm so confused...
thanks in advance
Votes: +0
I' m new to oracle what is AME & workflow??can anyone guide me what is that i'm so confused...
thanks in advance
report abuse
vote down
vote up
Consultant
written by Navin Hurree , July 07, 2010
written by Navin Hurree , July 07, 2010
Hi
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
Votes: +0
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
report abuse
vote down
vote up
Adding Voucher number to notification Subject line and body
written by Jsetti , October 19, 2010
written by Jsetti , October 19, 2010
Hi Anil,
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/
Jagadish
Votes: +0
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/
Jagadish
report abuse
vote down
vote up
Change Email Notification Only
written by Ed , June 14, 2011
written by Ed , June 14, 2011
Hi Anil
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.
Thanks
Ed
Votes: +0
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.
Thanks
Ed
report abuse
vote down
vote up
Oracle Technical Consutlant
written by Mohammed Rizk , April 28, 2012
written by Mohammed Rizk , April 28, 2012
Hi Jagadish,
Please 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,
Mohammed Rizk
Votes: +0
Please 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,
Mohammed Rizk
report abuse
vote down
vote up
| < Prev | Next > |
|---|
Can you please explain this line. It was not clear how to override the original template ? Can you provide screenshots as well.