Oracle EBS Workflow
文章平均质量分 82
田攀
tian.pan@qq.com
展开
-
Oracle Workflow Server/Client Downloads
Oracle Workflow Server/Client Downloadshttp://www.oracle.com/technetwork/database/options/index-092347.htmlOracle Workflow Server Downloads Oracle Workflow Server Release原创 2012-09-04 12:08:08 · 3963 阅读 · 0 评论 -
Configure your SMTP Server in Linux/Unix
Unable to connect SMTP port,There is a easy to check this.(ptian) ptian- telnet server_host 25Trying ip...telnet: Unable to connect to remote host: Connection refusedThis means probably, SMTP port 25原创 2013-02-27 16:49:17 · 5369 阅读 · 1 评论 -
Start/Stop the Workflow Services in Oracle Apps
Navigation:Navigate to Workflow Administrator> Oracle Application Manager > Workflow Manager > Service Components > Workflow Agent Listener Services Start and Stop the Oracle Workflow Services--------原创 2013-02-27 11:48:22 · 6327 阅读 · 0 评论 -
Oracle Workflow Tables
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.Ac原创 2012-11-09 17:41:07 · 4834 阅读 · 0 评论 -
Oracle Workflow Queries
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_ty原创 2012-11-09 17:43:13 · 4209 阅读 · 0 评论 -
How to run workflow using PL/SQL
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原创 2012-11-06 18:30:00 · 3587 阅读 · 0 评论 -
Useful Information about 'Workflow Background Process' Concurrent Program
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 t转载 2012-11-06 19:20:55 · 2946 阅读 · 0 评论 -
Oracle Workflow Demo (1) - 一个简单的请假申请工作流
目标:通过Oracle Workflow做一个简单的请假申请工作流,效果:经理接到流程后,可以Approve,也可以Reject。File > Quick Start WizardItem Type名字取得不好,让人不好理解,实际上Item Type可以就理解为工作流程序,一个Item Type下边,有一个或者多个Process,Process是工作流的核心。Persistence Type:Pe原创 2012-11-05 20:18:34 · 9139 阅读 · 0 评论 -
Oracle Workflow Demo (2) - Function
之前写了一篇工作流的Demo文章 - Oracle Workflow Demo (1) - 一个简单的请假申请工作流 ,这篇文章在那个工作流的基础上增加一些功能。增加一个Function来自动的判断Employee的Manager谁,然后把工作流走到那个对应的Manager上新增一个Function,属性中指定一个Procedure,这里可以先指定procedure,再来定义procedure然后原创 2012-11-06 19:03:15 · 4242 阅读 · 3 评论 -
Workflow Command - WFLOAD
UploadWFLOAD @ 0 Y {UPLOAD | UPGRADE | FORCE} 把工作流文件(wft文件)上传到数据库中Example:-WFLOAD apps/apps@instance 0 Y UPLOAD ABCDEFG.wftDifferent “Upload Modes” applicable to WFLOADUPLOAD - Honors only protection原创 2012-11-05 23:28:20 · 4437 阅读 · 1 评论 -
Workflow error:Unable to set NLS_LANGUAGE
使用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原创 2012-09-04 12:44:15 · 5231 阅读 · 0 评论 -
Workflows Articles
Oracle Workflow Training Lesson 1Oracle Workflows Training Lesson 2 Oracle Workflows Training Lesson 3 Workflows [Business Events] Training Lesson 4 DateItem TitleA原创 2012-09-05 14:33:48 · 2450 阅读 · 0 评论 -
Workflow Save as to Database,Encounter error: 1004: Language is not enabled
Workflow Save as to Database时,报两个错误Error1:220: Unable to set NLS_LANGUAGEError2:1004: Language is not enabled, please refers to Workflow documentation for steps on enabling a language.原创 2012-09-05 12:11:06 · 2978 阅读 · 0 评论 -
Workflow在EBS中的应用
EBS中部分工作流的应用下面的SQL可以查当前系统中所有的工作流:SELECT b.NAME, t.display_name, t.descriptionFROM wf_item_types b, wf_item_types_tl tWHERE b.NAME = t.NAMEAND t.LANGUAGE = 'US'ORDER BY 1Sample Ou原创 2012-09-04 12:23:10 · 3985 阅读 · 0 评论 -
Unable to start Workflow Notification Mailer
'Workflow Notification Mailer' Service is under status:'System Deactivated'.Detailed Status Information like below:---------------------------------------------------------This automatic Service Compo原创 2013-02-27 17:58:52 · 7614 阅读 · 0 评论