在ebs测试系统中，选择订单事务处理类型时，工作流类型选项中没有 “订单流-通用” 这一项，是否是缺少文件或者少打补丁？？请高手指教[@more@]

該LOV的SQL為.

select display_name, description, item_type, name, max(version) from wf_activities_vl where type = 'PROCESS' and nvl(end_date, sysdate) >= sysdate and item_type = 'OEOH' and runnable_flag = 'Y' and
name not like 'UPG_%'
group by display_name, description, name, item_type

至於設定的畫面,我想會有%FLOW%之類的權責.你再找找看.

VIEW:WF_ACTIVITIES 的SCRIPT為
/* Formatted on 2007/03/16 11:39 (Formatter Plus v4.8.0) */
CREATE OR REPLACE FORCE VIEW apps.wf_activities_vl (row_id,
item_type,
NAME,
VERSION,
TYPE,
rerun,
expand_role,
protect_level,
custom_level,
begin_date,
end_date,
FUNCTION,
result_type,
COST,
read_role,
write_role,
execute_role,
icon_name,
MESSAGE,
error_process,
runnable_flag,
error_item_type,
function_type,
event_name,
direction,
display_name,
description
)
AS
SELECT /* $Header: afwf.odf 115.157 2006/01/05 22:37:03 ybreddy ship $ */ b.ROWID
row_id,
b.item_type, b.NAME, b.VERSION, b.TYPE, b.rerun, b.expand_role,
b.protect_level, b.custom_level, b.begin_date, b.end_date,
b.FUNCTION, b.result_type, b.COST, b.read_role, b.write_role,
b.execute_role, b.icon_name, b.MESSAGE, b.error_process,
b.runnable_flag, b.error_item_type, b.function_type, b.event_name,
b.direction, t.display_name, t.description
FROM wf_activities b, wf_activities_tl t
WHERE b.item_type = t.item_type
AND b.NAME = t.NAME
AND b.VERSION = t.VERSION
AND t.LANGUAGE = USERENV ('LANG');

ITPub博客

订单工作流中找不到“订单流-通用”

最新文章