壹佰网|ERP100 - 企业信息化知识门户

 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 5741|回复: 6

workflow 邮件内容修改求教

[复制链接]
发表于 2007/4/5 12:19:43 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622  。

您需要 登录 才可以下载或查看,没有帐号?注册

x
大家好!

问题描述:
我在OAM中启动了 workflow manager的 Workflow Notification Mailer 功能,现在我们oracle hr模块的考勤模块,员工提交缺勤请求,Workflow Notification Mailer 会给下一个审批人发送一份邮件。
下一个审批人收到的邮件内容如下

From test1
To test2
Sent 05-Apr-2007 12:11:29
Due 04-Apr-2008 12:11:28
ID 6600
Attachments
Summary
Employee Number test1 Organization Email Address

Business Group Setup Business Group

Indicates Changed Items.

Absence Details
Proposed
假勤类型 加班
Start Date 21-Mar-2007
Start Time 07:00 PM
End Date 21-Mar-2007
End Time 10:00 PM
Hours 3.0
假勤原因 2007-03-21



Action History


Num Action Date Action From To Details
1 05-Apr-2007 12:11:29 Submit test1 test2



Copyright 2000-2005 Oracle Corporation. All rights reserved.

Please click on one of the following choices to automatically generate an E-mail response. Before sending the E-mail response to close this notification, ensure all response prompts include a desired response value within quotes.


Action: Approve Reject Request Information



需要解决的问题:
我现在就是需要修改邮件的内容。


研究好了好久,发现工作流发送邮件通知是通过包 wf_mail 来完成的。


图片中红色标注的是需要修改的地方



谢谢各位!
1.JPG
 楼主| 发表于 2007/4/5 16:16:54 | 显示全部楼层
次问题经过我一个下午的研究终于解决,现在还不是很成熟,我把方法帖出来,大家一起研究

解决办法如下:
1、此邮件是 workflow 系统发出的邮件。邮件的内容默认是按照系统的模版来进行发送的。
2、 workflow 系统默认是用此邮件的模版发送邮件的,如果你不想使用系统的模版,自己定义模版,你需要
      用ERP oracle database 用户登录,
       sqlplus <user/pwd> @afsvcpup.sql
    运行此脚本,需要设置三个参数
   第一个 component ID 你需要登陆 OAM 到workflow manager 去Workflow Notification Mailer 查找一下就知道了。
  第二个 parameter ID 你需要填入 Y
  第三个 我没有填写。
3、知道了系统发送邮件的模版格式之后,我用 workflow clinets 登陆之后,打开 “系统:邮件程序”,找到messages,然后找到 打开的邮件工作流 修改其属性保存即可。   
      
oracle 模版文件格式如下:
START_DATE  The date the message is sent.  
TO  The role the notification is sent to; the performer.  
SUBJECT  The subject line defined in the message.  
BODY  The text of the body defined in the message.  
COMMENT  Comments added by the sender or the forwarder.  
PRIORITY  The priority of the notification message.  
DUE_DATE  The date by which a response is required, specified in the notification activity.  
NOTIFICATION  Required notification code used to identify the information in the notification.  
RESPONSE  The user response section as defined by the Respond message attributes in the actual notification message definition.  
MAILTO  The content of the HTML tag that a recipient would click on to respond to a notification. This attribute is used only for HTML e-mail notifications.  
CLICK_HERE_ RESPONSE  The content of the HTML tag that a recipient would click on to access the Notification Details page to respond to a notification. This attribute is not currently used.  
SENDER  The name of the sender of the message, as displayed in the From column in the Worklist. This attribute is not currently used.  
HEADER  Standard header attributes and any custom header attributes defined to hold key information for the message. See: Header Attributes, Oracle Workflow Developer's Guide.  
HISTORY  The history of actions on the notification.  
TIMEZONE  The time zone of the dates and times displayed in the notification, based on the time zone of the server from which the notification was sent. This attribute is not currently used.  
You can customize the boilerplate text that appears in the body of the Workflow Open Mail (Direct) message, where attributes preceded by an ampersand (&) are token substituted with runtime values when the notification is sent.

The boilerplate text for a plain text message body is as follows:

Oracle Workflow Notification
&TIMEZONE
____________________________________________________

Response Instructions for &NOTIFICATION
To submit your response, reply to this message, including this note with your reply.  The first lines of your reply must be your responses to the notification questions.  Instructions below detail exactly what should be placed on each line of your reply.
&RESPONSE
____________________________________________________
Notification Details:
&HEADER
&BODY

Due Date: &DUE_DATE
&HISTORY
The boilerplate text for a HTML-formatted message body is as follows:

<HTML> <HEAD> <TITLE> Oracle Workflow Notification </TITLE><STYLE>
<!--
A:link {font-family:Arial,Helvetica,Geneva,sans-serif;font-size:10pt;color:#663300}
A:active {font-family:Arial,Helvetica,Geneva,sans-serif;font-size:10pt;color:#ff6600}
A:visited {font-family:Arial,Helvetica,Geneva,sans-serif;font-size:10pt;color:#996633}
-->
</STYLE> </HEAD>
<BODY BGCOLOR="#FFFFFF" >
<P><SPAN style="font-family:Arial,Helvetica,Geneva,sans-serif;font-size:10pt;font-weight:normal;color:#336699">&TIMEZONE
</SPAN>
<P>&HEADER
<P>&BODY
<P><SPAN style="font-family:Arial,Helvetica,Geneva,sans-serif;font-size:10pt;font-weight:normal;color:#000000">Please click on one of the following choices to automatically generate an E-mail response.  Before sending the E-mail response to close this notification, ensure all response prompts include a desired response value within quotes.
<P>&MAILTO </SPAN>
<P>&HISTORY
</BODY>
</HTML>
发表于 2007/4/5 18:13:34 | 显示全部楼层
不错,谢谢分享
发表于 2007/4/5 18:30:55 | 显示全部楼层
gaoyiming乃楷模也,值得erp100的家人学习!学习这种刻苦钻研的精神,学习这种奉献与分享的精神!
 楼主| 发表于 2007/4/7 16:15:27 | 显示全部楼层
原帖由 bob 于 2007-4-5 18:30 发表
gaoyiming乃楷模也,值得ERP100的家人学习!学习这种刻苦钻研的精神,学习这种奉献与分享的精神!



哈哈
感觉不好意思了
发表于 2007/6/14 11:18:13 | 显示全部楼层
不错,可以更好的学习WF
发表于 2007/6/18 14:06:22 | 显示全部楼层
贊一個!應該學習!
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|Archiver|小黑屋|手机版|壹佰网 ERP100 ( 京ICP备19053597号-2 )

Copyright © 2005-2012 北京海之大网络技术有限责任公司 服务器托管由互联互通
手机:13911575376
网站技术点击发送消息给对方83569622   广告&合作 点击发送消息给对方27675401   点击发送消息给对方634043306   咨询及人才点击发送消息给对方138011526

GMT+8, 2025/11/30 13:16 , Processed in 0.014671 second(s), 16 queries , File On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表