ITPub博客

Navigation:Navigate to Workflow Administrator> Oracle Application Manager > Workflow Manager > Service Components > Workflow Agent Listener Services Start and Stop the Oracle Workflow Services--------------------------------------------------------------------------------------------There also is a script to check all workflow service statusSET PAGESIZE 400 SET LINESIZE 120 SET PAGESIZE 50 COLUMN COMPONENT_NAME FORMAT A45 COLUMN STARTUP_MODE FORMAT A15 COLUMN COMPONENT_STATUS FORMA

Workflow Definition--Workflow Item Type的定义信息select * from wf_item_types where name = \'TPLEAVE\'select * from wf_item_types_tl where name = \'TPLEAVE\'--工作流里各个节点信息select * from wf_activities where item_type = \'TPLEAVE\';--End_Date没数据的那个版本，为当前有效版本--Version有多个，是因为你UPLOAD了多次，每次UPLOAD都会新增一个版本--Function的节点，那么Function中就会有对应的package.procedure的内容，比如ptleave.find_app

Workflow Definition TablesWF_ITEM_TYPESThe WF_ITEM_TYPES table defines an item that is transitioning through a workflow process.WF_ACTIVITIESWF_ACTIVITIES table stores the definition of an activity.Activities can be processes, notifications, functions or folders.A process activity is a modelled workflow process, which can be included as an activity in other processes to represent a sub-process.A notification activity sends a message to a performer. A functions activity performs an automated fu

What is the purpose of Workflow Background ProcessWorkflow Background Process is a concurrent program which is run for processing deferred activities, timed out activities, and stuck processes using the parameters specified. The background engine executes all activities that satisfy the given arguments at the time that the background engine is invoked. This procedure does not remain running long term, so you must restart this procedure periodically. Any activities that are newly deferred or ti

之前写了一篇工作流的Demo文章 - Oracle Workflow Demo (1) - 一个简单的请假申请工作流 ，这篇文章在那个工作流的基础上增加一些功能。增加一个Function来自动的判断Employee的Manager谁，然后把工作流走到那个对应的Manager上新增一个Function，属性中指定一个Procedure，这里可以先指定procedure，再来定义procedure然后在流程图中，新增一个Function图标，并关联上边新创建的Function，如果Result

Run workflow from PL/SQLdeclare v_itemtype varchar2(30):=\'TPLEAVE\'; --Item Type Internal Nam v_process varchar2(30):=\'DEFAULT_PROCESS\'; --Process Name v_itemkey varchar2(30); begin select rcv_transactions_s.nextval into v_itemkey from dual; --Assign a item key wf_engine.createprocess(v_itemtype, v_itemkey,v_process); --Creates a new runtime process for an application item. wf_engine.SetItemAttrText(v_itemtype ,v_itemkey,\'EMPLOYEE\',\'OPERATIONS\'); --Input Param

UploadWFLOAD <apps/pwd>@<connect_string> 0 Y {UPLOAD | UPGRADE | FORCE} <file_name.wft>把工作流文件(wft文件)上传到数据库中Example:-WFLOAD apps/apps@instance 0 Y UPLOAD ABCDEFG.wftDifferent “Upload Modes” applicable to WFLOADUPLOAD  - Honors only protection level of data [No respect of Customization Level]UPGRADE – Honors both protection and customization levels of dataFORCE   - Force upload regardless of protection or customization level注

目标：通过Oracle Workflow做一个简单的请假申请工作流，效果：经理接到流程后，可以Approve，也可以Reject。File > Quick Start WizardItem Type名字取得不好，让人不好理解，实际上Item Type可以就理解为工作流程序，一个Item Type下边，有一个或者多个Process，Process是工作流的核心。Persistence Type:Permanent:产生工作流信息永久性的保存，不会被清除掉，很少有流程要设置成permanentTemporary:工

Oracle Workflow Training Lesson 1 Oracle Workflows Training Lesson 2  Oracle Workflows Training Lesson 3  Workflows [Business Events] Training Lesson 4  Date Item Title Author Hits Thursday, 27 March 2008 Troubleshoot Business Event Subscription Processing Anil Passi 10166 Wednesday, 30 January 2008 How to send HTML Based Notification by a mere PL/SQL Call? Anil Passi 15543 Wednesday, 30 January 2008 Open Source in Oracl

Workflow Save as to Database时，报两个错误 Error1: 220: Unable to set NLS_LANGUAGE Error2: 1004: Language is not enabled, please refers to Workflow documentation for steps on enabling a language. 原因： 环境变量NLS_LANG设置不正确，正确应为AMERICAN_AMERICA.AL32UTF8，但之前设置成了‘SIMPLIFIED CHINESE_CHINA.AL32UTF8’， 设置完之后，重启workflow builder，重新拉‘Standard’模板workflow，重新设置workflow，再save as就没问

使用Workflow Builder打开数据库的时候报"Unable to set NLS_LANGUAGE"的错误Error:220: Unable to set NLS_LANGUAGE.210: Oracle Error: ORA-01403: 未找到任何数据.  SQL text: SELECT NLS_LANGUAGE FROM WF_LANGUAGES WHERE :l IN (NLS_LANGUAGE, CODE)解决方法：参考：https://forums.oracle.com/forums/thread.jspa?threadID=842655Set NLS_LANG as an operating system environment variable:   1. Select Start - Control Panel - System   2. Select Environment &nbsp

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 Accoun

Oracle Workflow Server/Client Downloads http://www.oracle.com/technetwork/database/options/index-092347.html Oracle Workflow Server Downloads     Oracle Workflow Server Release 10.1.0.3 for Apple Mac OS X Oracle Workflow Server Release 10.1.0.3 for Linux x86-64 Oracle Workflow Server Release 10.1.0.3 for Linux x86 Oracle Workflow Server Release 10.1.0.3 for z/Linux Oracle Workflow Server Release 10.1.0.3 for Solaris x86 Orac