精华内容
下载资源
问答
  • 2014-09-28 14:02:44
    

    Troubleshooting Workflow Notification Mailer IssuesFind Workflow Notification Mailer is up and Running?
    SELECT component_name, component_statusFROM fnd_svc_componentsWHERE component_type = 'WF_MAILER';
    Workflow logs: FNDCPGSC*.txt under $APPLCSF/$APPLOG directoryFind the Failed Ones?
    Select NOTIFICATION_ID, MESSAGE_TYPE, MESSAGE_NAME, STATUS, MAIL_STATUS, FROM_USER, TO_USER from wf_notifications where MAIL_STATUS='FAILED';
    Check pending e-mail notification that was pending for process.
    Sql> SELECT COUNT(*), message_name FROM wf_notificationsWHERE STATUS='OPEN'AND mail_status = 'MAIL'GROUP BY message_name;
    Sql> SELECT * FROM wf_notificationsWHERE STATUS='OPEN'AND mail_status = 'SENT'ORDER BY begin_date DESC
    Check the Workflow notification has been sent or not?
    select mail_status, status from wf_notifications where notification_id=<notification_id>
    --If mail_status is MAIL, it means the email delivery is pending for workflow mailer to send the notification
    --If mail_status is SENT, its means mailer has sent email
    --If mail_status is Null & status is OPEN, its means that no need to send emailas notification preference of user is "Don't send email"
    --Notification preference of user can be set by user by logging in application +click on preference + the notification preference
    1. Verify whether the message is processed in WF_DEFERRED queue
    select * from applsys.aq$wf_deferred a where a.user_data.getEventKey()= '<nid>'<nid> - notification id
    2. If the message is processed successfully message will be enqueued to WF_NOTIFICATION_OUT queue, if it errored out it will be enqueued to WF_ERROR queue
    select wf.user_data.event_name Event_Name, wf.user_data.event_key Event_Key,wf.user_data.error_stack Error_Stack, wf.user_data.error_message Error_Msgfrom wf_error wf where wf.user_data.event_key = '<nid'>To check what all mails have went and which all failed ?
    Select from_user,to_user,notification_id, status, mail_status, begin_datefrom WF_NOTIFICATIONS where status = 'OPEN';
    Select from_user, to_user, notification_id, status, mail_status,begin_date,USER_ KEY,ITEM_KEY,MESSAGE_TYPE,MESSAGE_NAME begin_datefrom WF_NOTIFICATIONS where status = 'OPEN';


    Users complain that notifications are stuck ?
    Use the following query to check to see whatever the users are saying is correct
    SQL> select message_type, count(1) from wf_notificationswhere status='OPEN' and mail_status='MAIL' group by message_type;
    E.g o/p of query -
    MESSAGE_Type COUNT(1)
    -------- ----------
    POAPPRV 11 --- 11 mails of Po Approval not sent --
    -
    INVTROAP 12
    REQAPPRV 9
    WFERROR 45 --- 45 mails have error
    If Mail not received by User ?
    select Name,DISPLAY_NAME,EMAIL_ADDRESS,NOTIFICATION_PREFERENCE,STATUSfrom wf_users where DISPLAY_NAME=xxx,yyy;
    StatusActive
    Notification_preference-> Mailtext
    Email Address should not be null
    Notification not sent waiting to be mailed ?
    SQL> select notification_id, status, mail_status, begin_date from WF_NOTIFICATIONSwhere status =OPENand mail_status =MAIL;
    To debug the notification id ?
    $FND_TOP/sqlrun wfmlrdbg.sql
    Change Mail Preferences for all Application Users (FND USERS)How to mass change Mail Preferences for FND USERS [ID 451929.1]
    Solution :Using sqlplus as the apps user:
    1st Method:
    1.update wf_local_rolesset notification_preference = 'MAILHTML'
    where user_flag='Y'
    2.update fnd_user_preferencesset preference_value = 'MAILHTML'where module_name = 'WF'and preference_name = 'MAILTYPE'
    commit;
    2nd method:
    Navigation: Connect to Applications as Sysadmin user and select responsibility
    Workflow Administrator Web Applications --> Administration --> Global Preferences

    Tablespace Usage/Free
    TEMP Usage per session ?
    SELECT S.sid || ',' || S.serial# sid_serial, S.username, S.osuser, P.spid, S.module,S.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.tablespace,COUNT(*) sort_opsFROM v$sort_usage T, v$session S, dba_tablespaces TBS, v$process PWHERE T.session_addr = S.saddrAND S.paddr = P.addrAND T.tablespace = TBS.tablespace_nameGROUP BY S.sid, S.serial#, S.username, S.osuser, P.spid, S.module,S.program, TBS.block_size, T.tablespaceORDER BY sid_serial;
    Temp Space used/free?
    select tablespace_name, bytes_used/1024/1024, bytes_free/1024/1024 from v$temp_space_header;
    Users Using Temp tablespace?
    select b.tablespace, (b.blocks*p.value)/1024/1024 , a.sid, a.username from sys.v _$session a, sys.v_$sort_usage b, sys.v_$parameter pwhere p.name=b.session_addr;
    To get which user is using temp tablespace ?
    select username,tablespace,extents from v$sort_usage;
    Free and Used Space in Temp Tablespace ?
    SELECT A.tablespace_name tablespace, D.mb_total,SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,

    更多相关内容
  • Oracle WorkFlow基础笔记

    2021-05-06 00:50:07
    比如完成否,返回值 wf_notifications,保存工作流实例的notifications消息,基本是按顺序的,可以看发给谁了 wf_roles,角色视图,工作流援用角色的根据,有mail地址等信息 wf_user_roles,用户和角色关系视图,...

    1. Workflow Builder的默许访问级别是100,以下是Oracle对访问级别的1个大致分类:

    0⑼ Oracle Workflow

    10⑴9 Oracle Application Object Library

    20⑼9 Oracle Application Development

    100⑼99 Customer Organization

    1000 Public

    1xQAAAAASUVORK5CYII=2. Oracle 工作流对象通过不同的选项和访问级别来实现对象的保护

    H0myNAMBmTtIAAAAAElFTkSuQmCC

    1xQAAAAASUVORK5CYII=3. Workflow安装

    1、可以直接使用8i的http,不用安装IAS,根据Server安装指南配置httpd.conf的别名便可;http服务起不来的可能情况2、

    httpd.conf语法毛病,这个没甚么好说的

    之前的服务没有正常结束,1般重新启动计算机便可;或杀掉java进程,如果有的话

    新安装了Oracle其它产品,致使路径援用毛病;我的解决办法是把新安装软件在环境变量Path中添加的路径移到最后

    如果要看httpd为什么没法启动,查看Log是没用的;应当先运行CMD,然后cd到需要的目录,输入apache.exe,这个时候就会有毛病出现

    2、Notification默许的配置是html email,这个时候易遇到Notification就报错,

    由于我们自己1般没有配置Mail服务器,所以需要在Global Workflow Preferences里面把Send me electronic mail notifications设置为Do not send me mail

    3、开始我没有配好Business Event System,在履行Aprove等动作的时候总是No Data Found;

    后来我根据Error Stack找到wf_xml包,把里面的RemoveNotification的Raise语句注释掉就能够了。嘿嘿,反正我是自己研究工作流,无所谓了

    4、我的系统是XP Home SP1,没有JVM,没法View Diagram;装了JDK,不太好用,卸掉装msjavx86.exe1切正常

    1xQAAAAASUVORK5CYII=4.刚接触Workflow Builder会碰到的几个疑问

    如何连接各个Node:用右键而不是左键连

    为什么修改不了他人的文件:在Help菜单里面设置适合的Access Level

    为什么图标不起作用:在View菜单里面选择Develop Mode

    如何使用Standard的Item:打开Standard或Demo文件,把Stantard这个Item Type抓过去

    Notification根据甚么发:必须在Process里面打开Notification的属性,Node标签里面有1个Performer,根据需要设置成我们预定义的某个Role类型的Attribute

    Workflow Builder的PL/SQL函数有甚么要求:拷个Demo的函数,照着写就能够了,怎样判断运行模式,怎样返回里面都有

    其他问题其实Workflow Builder在保存或我们选择Verify的时候都会提示,只要认真看都能解决

    1xQAAAAASUVORK5CYII=5.对各个Item的通俗理解

    1、Item Type是个抽象的概念,为方便理解,可以看做是1个工作流的容器和标志

    2、Attribute是全局变量,供全部Item Type里面的元素使用,可以作为message的附加属性,Send给用户看或存储用户的Response内容比如Note和Forward To;Attribute另外一个经常使用的地方是作为Notification的Performer。固然我们的PL/SQL代码是离不开Attribute,几近任何PL/SQL函数都需要通过获得Attribute变量--判断Attribute变量--设置Attribute变量,决定程序如何走,返回甚么值

    3、Message,就是1个消息,内容在Body里面定义,用&援用Message自己的Attribute;对我们程序有用的的是Message的Attribute,1般和上面的全局变量Attribute对应,Send类型的Attribute将取当时的全局变量Attribute的值发给用户看,Response类型Attribute将把用户输入的内容返回给全局变量Attribute供我们的程序作下1步判断使用

    4、Lookup Types,基础字典列表,就像我们的部门字典表,销售方式字典表1样,不过它是静态的;根据需要设置,1般用来标志工作流各类Item的返回值,和我们的PL/SQL函数返回值逐一对应

    5、Function,就是Function,1个处理,1般对应1个PL/SQL函数并定义返回值为某个Lookup Type

    6、Notification,发送1个消息,消息内容为定义的Message内容,消息的接收人是定义的Performer

    7、Process,真实的流程,由Notification、Function、子Process组成,开始于1个Start Function,结束于1个或多个End Function,中间是Notification和Function组成的业务流程,在这个级别上可以把Notification、Function、子Process看成是1样的即activity,他们都有返回值,不同的结果走不同的流程,由此组成1个符合业务需要的图表

    1xQAAAAASUVORK5CYII=6.由Engine管理、不需要我们操心的东西

    1、消息发送;我们只管定义,由于可以用HTML写Message的Body,可以定义得很漂亮

    2、流程选择;我们只管按不同的返回结果画图,Engine会根据我们函数的返回值调用下1个activity

    3、用户选择;我们可以修改wf_roles、wf_users、wf_user_roles这3个视图,使之包括我们业务系统的用户便可

    1xQAAAAASUVORK5CYII=7.经常使用表

    1.Workflow Definition Tables

    WF_ITEM_TYPES

    WF_ACTIVITIES

    WF_MESSAGES

    WF_ITEM_ATTRIBUTES

    WF_ACTIVITY_ATTRIBUTES

    WF_MESSAGE_ATTRIBUTES

    WF_PROCESS_ACTIVITIES

    WF_ACTIVITY_TRANSITIONS

    2. Workflow Runtime Tables

    WF_ITEMS

    WF_ITEM_ACTIVITY_STATUSES

    WF_NOTIFICATIONS

    WF_MESSAGES

    WF_NOTIFICATION_ATTRIBUTES

    3. Business Event Tables

    WF_SYSTEMS

    WF_AGENTS

    WF_EVENTS

    WF_EVENT_SUBSCRIPTIONS

    4. 各表解析

    wf_item_types_vl,保存工作流的定义,即类

    wf_items,保存实际的工作流,或说工作流的对象实例

    wf_item_attribute_values,保存工作流实例的attribute最新值

    wf_item_activity_statuses,保存工作流实例的各个activity的状态,比如完成否,返回值

    wf_notifications,保存工作流实例的notifications消息,基本是按顺序的,可以看发给谁了

    wf_roles,角色视图,工作流援用角色的根据,有mail地址等信息

    wf_user_roles,用户和角色关系视图,工作流可以根据它进行“群发”

    1xQAAAAASUVORK5CYII=8. 签合层级

    (1). Hierarchy头

    SELECT *

    FROM PER_POSITION_STRUCTURES_V PS

    WHERE PS.NAME = 'XXXXXXXX'; -⑹4

    (2).Hierarchy行

    SELECT *

    FROM PER_POS_STRUCTURE_ELEMENTS_V PE

    WHERE PE.POS_STRUCTURE_VERSION_ID = 64;

    (3).Hierarchy生成表

    SELECT *

    FROM PO_EMPLOYEE_HIERARCHIES H

    WHERE H.POSITION_STRUCTURE_ID = 64

    AND H.EMPLOYEE_ID <> H.SUPERIOR_ID;

    --职位表

    SELECT * FROM select * from PER_ALL_PEOPLE_F P WHERE P.NAME = 'YYYYY'; -⑼3

    --职位分配

    SELECT * FROM PER_ALL_ASSIGNMENTS_F A WHERE A.POSITION_ID = 93; -⑼60

    --人员

    SELECT * FROM PER_ALL_PEOPLE_F AP WHERE AP.PERSON_ID = 960;

    --要求

    Fill Employee Hierarchy

    1xQAAAAASUVORK5CYII=9.没有收到Notification

    1. 程序毛病,没有设置正确的Notification Performer

    2. 如果是PO,可能没跑Fill Employee Hierarchy

    3. 1个Employee分配给了多个User,那末其实只有第1个User收到了消息

    4. 数据还没有同步到Workflow,即没跑Synchronize Workflow LOCAL tables

    1xQAAAAASUVORK5CYII=10. Workflow Role的类型

    PNAasWFtiLIq+otbVuMYrvZc1jY7q1VFGGLpKR5bFw5WAYlcUxcb0V8npTcuV1Mt97VWthgb2o8nr3WlvLFliFAq0ieTVoCJcGypRXAK4NvLpxXBoI8gpuAby6cVwaCPIKbgG8unFcGgjyCm4BvLpxXBqIyytqbQEAQC14ra3XHwB4Al7dOC4NRE8K8grcAq9uHJcGEuQVAABAXf4PqFzCfNmCAxAAAAAASUVORK5CYII=

    1xQAAAAASUVORK5CYII=11. Approve_Id, Approve_Name, Approve_Display Name 的必须建立

    对程序来讲ID是关键的,来源于各个表如FND_USER或HR_EMPLOYEES;

    对Workflow来讲Name是关键的,来源于表WF_ROLES;

    对终究User来讲,Display Name是关键的,来源于表WF_ROLES;

    1xQAAAAASUVORK5CYII=12. 隐藏Notification中的1些默许Button

    #HIDE_REASSIGN,可以隐藏标准的Reassign按钮

    #HIDE_MOREINFO,可以隐藏标准的Request Information按钮

    1xQAAAAASUVORK5CYII=13. Workflow的Activity的节点的7个状态

    Active--activity is running.

    Complete--activity completed normally.

    Waiting--activity is waiting to run.

    Notified--notification activity is delivered and open.

    Deferred--activity is deferred.

    Error--activity completed with error.

    Suspended--activity is suspended.

    Thanks and Regards

    展开全文
  • 摘自:...Some times Due to large number of e-mail notifications to accumulated in the queue Workflow mailer will not start,T

    摘自:http://mtalmasri.blogspot.tw/2012/05/how-to-purge-e-mail-notifications-from.html

    Some times Due to large number of e-mail notifications to accumulated in the queue Workflow mailer will not start,To fix this issue we need purge the notifications from the Workflow queue.


    The below outlines the steps, Please take proper backup before performing the below.

    1) You need to update the notifications you do not want sent, in the WF_NOTIFICATIONS table.

    2) Check the WF_NOTIFICATIONS table as below. Records where status = 'OPEN' and mail_status = 'MAIL' are notifications that will have an e-mail notification sent.

    SQL> select notification_id,status,mail_status,begin_date from WF_NOTIFICATIONS where status = 'OPEN' and mail_status = 'MAIL';

    3) This should show you which notifications are waiting to be e-mailed.

    4) To update a notification so that it will not get e-mailed. Set the MAIL_STATUS = 'SENT'. The mailer will think the e-mail has already been sent and it will not send it again.

    SQL> update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';

    -> This will update all notifications waiting to be sent by the mailer.

    5) Then run the script wfntfqup.sql to purge the WF_NOTIFICATION_OUT queue and rebuild it with data currently in the WF_NOTIFICATIONS table. This is what purges all notifications waiting in the queue to be sent.Only the ones where mail_status = 'MAIL' and status = 'OPEN' will be placed in the WF_NOTIFICATION_OUT queue and sent by the mailer.

    SQL>sqlplus apps/apps_pwd @$FND_TOP/patch/115/sql/wfntfqup APPS APPS_PWD APPLSYS

    6) Now you can start your WF Containers and then Mailer

    展开全文
  • Workflow相关表简单分析

    千次阅读 2014-08-19 23:09:10
    静态定义表(没有ITEM_KEY,因为ITEM_KEY代表一个wf实例)   --获取item_type定义。 SELECT * FROM wf_item_types t WHERE t.name= 'CUX_TEST';   /*查询指定ITEM_TYPE中新建的activitie定义(没有activity的id)。*/ ...

    静态定义表(没有ITEM_KEY,因为ITEM_KEY代表一个wf实例)

     

    --获取item_type定义。

    SELECT * FROM wf_item_types t WHEREt.name= 'CUX_TEST';

     

    /*查询指定ITEM_TYPE中新建的activitie定义(没有activity的id)。*/

    SELECT *

      FROM wf_activities_tlt

     WHERE t.item_type= 'CUX_0005'

       AND t.version= 1;

     

    /*查询指定PROCESS所属的ITEM_TYPE中新建的activitie和该ITEM_TYPE所引用的其他Item_type中的activities的并集。*/

    SELECT *

      FROM wf_process_activitiest

     WHERE t.process_item_type= 'CUX_0005'

       AND t.process_version= 1;

     

    /*查询指定ITEM_TYPE中的Message*/

    SELECT * FROM wf_messages t WHEREt.type= 'CUX_TEST';

     

    /*分别获取指定ITEM_TYPE下,item_type级别、message级别和activity级别的attribute定义。*/

    SELECT * FROM wf_item_attributes t WHEREt.item_type = 'CUX_TEST';

    SELECT * FROM wf_message_attributes tWHEREt.message_type = 'CUX_TEST';

    SELECT * FROM wf_activity_attributes tWHEREt.activity_item_type = 'CUX_TEST';

     

    动态实例表(有ITEM_KEY,代表一个运行起来的wf实例)

    /*指定ITEM_TYPE和ITEM_KEY,获取一个process运行实例*/

    SELECT *

      FROM wf_itemst

     WHERE t.item_type= 'CUX_T2'

       AND t.item_key= 'CUX_TEST_ITEM_KEY_056';

     

    /*指定ITEM_KEY,查看该PROCESS发送的所有的Notificatio*/

    SELECT t.message_type

          ,t.message_name

          ,t.recipient_role

          ,t.original_recipient

          ,t.status--通知的当前状态(CLOSED表示已经审批完成;CANCELED表示超时;OPEN表示正在审批中。)

          ,t.mail_status

           /*在相应接收人成功登录系统后,系统才会为以下三个字段设置值;

           在接收人登录系统之前,它们的值为空。(不知为何?)*/

          ,t.from_role--通知发送角色

          ,t.from_user--工作列表的发发件人字段

          ,t.to_user--通知的接收人

          ,t.begin_date

          ,t.end_date

          ,t.due_date

          ,t.*

      FROM wf_notificationst

     WHERE t.item_key= 'CUX_TEST_ITEM_KEY_055';

     

    /*Notification的审批结果(审批意见)表,一般与wf_notifications表相关联*/

    SELECT t.notification_id

          ,t.from_user

          ,t.to_user

          ,t.user_comment

          ,t.comment_date

      FROM wf_commentst

     WHERE t.notification_id= 712867;

     

    /*指定ITEM_TYPE和ITEM_KEY,指定一个activity名称(包括Process名称,因为Process也是一个activity),

    获取该activity当前的运行状态*/

    SELECT t.assigned_user --表示一个notification的接收人(即NotificationPerformer值),如果当前activity不是一个notification,则该字段为空。

          ,t.*

          ,pa.*

      FROM wf_item_activity_statusest

          ,wf_process_activities     pa

     WHERE 1 = 1

       AND t.process_activity=pa.instance_id

       AND t.item_type= 'CUX_T2'

       AND t.item_key= 'CUX_TEST_ITEM_KEY_067';

     

    /*指定notification,获取其属性的值(比如用户的审批结果)*/

    SELECT n.notification_id

          ,n.status

          ,na.name

          ,na.text_value

          ,na.number_value

          ,na.date_value

          ,na.event_value

      FROM wf_notifications           n

          ,wf_notification_attributesna

     WHERE n.notification_id= na.notification_id

       AND n.item_key= 'CUX_TEST_ITEM_KEY_055';

     

    /*当前PROCESS中所有活动的当前属性值*/

    SELECT *

      FROM wf_item_attribute_valuesval

     WHERE val.item_type= 'CUX_T2'

       AND val.item_key= 'CUX_TEST_ITEM_KEY_055';

     

    /*关于发件人相关表的分析,以下的from/to字段都可以通过手工update后台表来改变页面的显示内容。*/

    SELECT n.notification_id

           --n.from_user,该字段显示为系统主页的工作列表以及通知明细题头部分的发件人

          ,n.from_usern_from_user

           --n.to_user,该字段显示为通知明细题头部分的

          ,n.to_usern_to_user

           --c.from_user,该字段显示为系统通知明细行部分的

          ,c.from_userc_from_user

           --c.to_user,该字段显示为系统通知明细行部分的

          ,c.to_userc_to_user

      FROM wf_notificationsn

          ,wf_comments      c

     WHERE 1 = 1

       AND c.notification_id= n.notification_id

       AND n.item_key= 'CUX_TEST_ITEM_KEY_067';

     

    展开全文
  • EBS Workfow常用表

    2016-09-14 15:30:00
    1.Workflow Definition ...WF_ITEM_TYPES WF_ACTIVITIES WF_MESSAGES WF_ITEM_ATTRIBUTES WF_ACTIVITY_ATTRIBUTES WF_MESSAGE_ATTRIBUTES WF_PROCESS_ACTIVITIES WF_ACTIVITY_TRANSITIONS 2. Workflow ...
  • Oracle EBS WorkFlow 开发笔记总结

    千次阅读 2015-08-26 09:59:30
     FROM wf_notifications wfn   WHERE wfn.message_type = 'Item type 的 Internal name'  AND wfn.subject LIKE ' message 标 题 '   ORDER BY wfn.notification_id DESC   --获取流程实例的...
  • 本文来源:... 问题描述 在做Oracle EBS工作流列表开发的时候,可以使用如下SQL获取系统工作流列表: --sql已做精简 SELECT /*+ ORDERED PUSH_SUBQ USE_NL (WN WL WIT) index(WN WF_NOTIFICATIONS
  • notifications and hence, lookups types) Cause The mailer is unable to interpret other languages other than the base install language. This was found to be due to the nature by which the ...
  • Oracle Workflow Tables

    2014-07-02 14:00:58
    Workflow Definition TablesWF_ITEM_TYPESThe WF_ITEM_TYPES table defines an item that is transitioning through a w...
  • 步骤如下:更新WF_NOTIFICATIONS 中的STATUS为CLOSED,MAIL_STATUS为SENT。如果STATUS为OPEN,MAIL_STATUS为MAIL,表示这部分数据将被送入发送队列。因此,此处需要手工标记为已发送。 $FND_TOP/patch...
  • WorkFlow常用的一些情形

    千次阅读 2016-04-20 11:10:35
    wf_engine.startprocess(itemtype => l_item_type, itemkey => l_item_key); internal name:就是itemtype itemkey是自己随意取的,一般都是有流水码,防止重复 itemkey一般要记录下来,因为以后我们要对此 ...
  • PO核准通知界面修改

    千次阅读 2014-08-09 23:14:09
    -- approval notifications l_supplier := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_item_type, itemkey => l_item_key, aname => 'SUPPLIER'); l_supplier_site := PO_WF_UTIL_PKG.GetItemAttrText...
  • Oracle Workflow Queries

    2021-05-05 06:52:34
    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_...
  • 适用于:11.5到12在workflow mailer没有启动之前,邮件队列中有很多等待发送的mail,一旦workflow mailer启动,...1 SELECT NOTIFICATION_ID, STATUS, MAIL_STATUS, BEGIN_DATE2 FROM WF_NOTIFICATIONS3 WHERE ST...
  • wf_notifications,保存工作流实例的notifications消息,基本是按顺序的,可以看发给谁了 wf_roles,角色视图,工作流引用角色的依据,有mail地址等信息 wf_user_roles,用户和角色关系视图,工作流可以根据它...
  • 工作流问题排查

    2016-08-04 10:45:51
    ----查当前系统中所有的工作流: ... FROMwf_item_types b, wf_item_types_tl t  WHERE b.NAME =t.NAME  ANDt.LANGUAGE = 'ZHS'  ORDER BY 1   ----查看当前的Workflow管理员,用其登陆EBS
  • Oracle WorkFlow(工作流)(二)

    千次阅读 2012-06-22 14:20:53
    2.4消息(Message) 消息主要是为通知服务的,可以把消息当作通知的内容和类型。消息也属于一个单据类型,通知只能和同一... wf_notifications 保存工作流实例的notifications消息,基本是按顺序的,可以看发给谁...

空空如也

空空如也

1 2 3 4 5 ... 17
收藏数 322
精华内容 128
关键字:

wf_notifications

友情链接: advertise.rar