Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Oracle Workflows - All Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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.




Anil Passi

Comments   

0 #1 Debojyoty Sadhukhan 2008-08-01 10:02
Specify this new template by overriding a specific notification, example "PO Approval Notification"

Can you please explain this line. It was not clear how to override the original template ? Can you provide screenshots as well.
Quote
+1 #2 Anil Passi 2008-08-01 10:06
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




Th anks,
Anil
Quote
0 #3 fadi hasweh1 2008-08-01 13:20
good post anil, keep them coming
fadi
Quote
0 #4 kirti 2008-08-01 13:26
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/creat e quote to rfi/rfq
2. online discussion to send as message
Quote
0 #5 Anil Passi 2008-08-01 14:34
Folks,

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
Quote
0 #6 Anil Passi 2008-08-01 14:36
Hi Kirti

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
Quote
0 #7 Linesh PIllai 2008-08-02 17:41
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
Quote
0 #8 Anil Passi 2008-08-02 18:06
Metalink Note:283248.1 is a good reference point, please visit that note
Quote
0 #9 Harish 2008-08-05 16:37
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
Quote
0 #10 Anil Passi 2008-08-05 16:44
Hi 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
Quote
0 #11 Harish 2008-08-06 01:36
Thanks Anil!
Quote
0 #12 Norman 2008-08-08 05:27
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_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.
Quote
0 #13 Anil Passi 2008-08-08 06:06
Hi Norman

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
Quote
0 #14 Norman 2008-08-20 00:54
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_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
Quote
0 #15 Norman 2008-08-20 02:58
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.
Quote
0 #16 Kirti Kumar Gupta 2008-08-24 04:00
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).

P lease let me know how to achieve these points.
Quote
0 #17 Kirti Kumar Gupta 2008-08-24 04:04
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.

Plea se advise how to resolve this.

Thanks n Regards
Kirti
Quote
0 #18 kiranp9949 2009-12-25 13:52
Hi guys,

I' m new to oracle what is AME & workflow??can anyone guide me what is that i'm so confused...

th anks in advance
Quote
0 #19 Navin Hurree 2010-07-07 04:41
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
Quote
0 #20 Jsetti 2010-10-19 10:28
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/
Jagadi sh
Quote
0 #21 Ed 2011-06-14 22:58
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.
Thank s
Ed
Quote
0 #22 Mohammed Rizk 2012-04-28 10:28
Hi Jagadish,
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
Quote
0 #23 Iva 2012-11-08 04:38
Hello,

I need to turn off one FYI notification (OTA_LNR_ENROLL _STS_NTF_NO) in Oracle Workflow Builder.

How to do this?

Regards,
Iva
Quote
0 #24 Kranthi Kumar M 2014-10-09 21:31
Hi,

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.
Quote
0 #25 FelixL 2015-03-10 07:50
hi Anil,

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
Quote
0 #26 Amit Mitra 2015-10-05 13:42
Hi Anil,

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
Quote
0 #27 kalvenku 2015-12-07 05:44
Hi Anil,

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.
Quote
0 #28 kalvenku1 2015-12-07 06:18
Hi Anil,

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.
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213
14151617181920
21222324252627
282930    

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner