Workflow在EBS中的应用

EBS中部分工作流的应用

下面的SQL可以查当前系统中所有的工作流:

SELECT b.NAME, t.display_name, t.description
FROM wf_item_types b, wf_item_types_tl t
WHERE b.NAME = t.NAME
AND t.LANGUAGE = 'US'
ORDER BY 1

Sample Output(Inventory Workflow)

NAME	DISPLAY_NAME
INVADJTO	Inventory Adjustment XML Outbound
INVCDNTF	Consigned Inventory Diagnostics
INVDATNT	Inventory Date Notification
INVFLXWF	Inventory Cost of Goods Sold Account
INVMOQD	INV Sync Onhand Outbound
INVSHMSG	Material Shortage Message
INVTROAP	INV: Move Order Approval

工作流的进化

• R10.7 - Flex Field builder 流程组织型

• R11 - Workflow 2.03 流程组织型

• R11i - Workflow 2.6 流程组织型 + 事件驱动型

Workflow的下载

Oracle Workflow Server/Client Downloads

参考：<<深入浅出Oracle_EBS之Workflow实例详解.pdf>>