Oracle ERP最佳技术实践
Workflow
File Ref: 深入浅出Oracle EBS之Workflow实例详解.docx (v. DRAFT 1A )
Company Confidential - For internal use only
Doc Ref: <Document Reference Number>
November 11, 2010
Document Control
iii
Contents
Document Control .................................................................................................................. ii
1. Oracle Workflow基础 ............................................................................................... 2
1.1. 工作流概述 .......................................................................................................... 2
1.2. 必要设置 .............................................................................................................. 7
1.3. 先睹为快：一个简单例子.Start to End ............................................................ 8
1.4. 先睹为快：一个简单例子.Save to Database ................................................. 13
1.5. 先睹为快：一个简单例子.运行 ....................................................................... 14
2. 其他特性和功能实例 ............................................................................................... 18
2.1. 第2个例子：Notification ................................................................................. 18
2.2. 第3个例子：Lookup Types和分支处理Function ......................................... 25
2.3. 第4个例子：Loop、Timeout、Defer和Workflow Background Process .. 41
2.4. 第5个例子：Wait、Wait/Continue Process ................................................ 48
2.5. 第6个例子：Document、Forms、Function Result、隐藏标准按钮 ......... 55
3. 常用代码块 ............................................................................................................... 62
3.1. Startup ............................................................................................................... 62
3.2. Notification ....................................................................................................... 63
3.3. Active节点和当前属性值 ................................................................................. 64
3.4. Retry和Skip ...................................................................................................... 65
3.5. Complete ........................................................................................................... 66
3.6. 处理Defer .......................................................................................................... 66
3.7. 建立父子关系 .................................................................................................... 66
3.8. Document和Forms .......................................................................................... 67
3.9. Test工作流 ........................................................................................................ 69
3.10. Cancel/Abort工作流 ....................................................................................... 70
3.11. Purge工作流实例/定义 ................................................................................... 70
3.12. 最新n条Notification ........................................................................................ 71
3.13. 等待发送Mail的Notification ........................................................................... 71
3.14. Queue相关 ........................................................................................................ 71
3.15. 未完待续 ............................................................................................................ 72
4. 审批路径 ................................................................................................................... 73
4.1. 客户化表 ............................................................................................................ 73
4.2. 员工上下级 ........................................................................................................ 73
4.3. 职位层次 ............................................................................................................ 73
4.4. OAM/AME ...................................................................................................... 73
5. Workflow Notification Mailer Configuration ..................................................... 78
5.1. Basic ................................................................................................................... 78
5.2. Database Layer ................................................................................................. 79
5.3. Application Layer ............................................................................................ 80
评论0