分享
 
 
 

Oracle erp销售订单订单行状态不对导致订单无法关闭之解决方案!

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

销售订单行booked后,挑库到待发库,忽然决定不再发货,对订单行作backordered,但是订单行的状态没有变为cancle,仍然是picked,导致整个订单无法关闭!具体操作步骤:

### Steps to ReprodUCe ###

1)om/order organizer /new sale order i create an sale order ,entry order line ordered item:C.BT.250-100G-2.8.J

02 qty: is 11

2) om/ship transaction/pick release reserved 11.and transer to satged subinventory 'DFK'.

3) later,i don't want to ship it to custmer, in ship transaction form, i do backordered,delivery is clos

ed,but order line status is

picked, in ship transaction form, query it ,line pick status is staged, reserved is not released.Souliton:Dwon the script from MetalinkREM $Header: single.sql 115.0 2000/06/15 01:55:37 ysinha noship $ WHENEVER SQLERROR EXIT FAILURE ROLLBACK;set ver offset feed offset serveroutput on size 500000Promptaccept order_line_id number prompt 'Enter LINE_ID of the Line to Cancel : 'spool &order_line_idcol dtime format a25 heading 'Script run at Date/Time' ;select to_char(sysdate, 'DD-MON-YYYY HH:MI:SS') dtime from dual;Declare l_line_id number := &order_line_id; l_user_id number; l_resp_id number; l_resp_appl_id number; l_wf_exists varchar2(1) := 'Y';Begin update oe_order_lines_all set ordered_quantity = 0 , cancelled_quantity = nvl(cancelled_quantity, 0) + ordered_quantity , cancelled_flag = 'Y' , open_flag = 'N' , flow_status_code = 'CANCELLED' , last_updated_by = -2564702 , last_update_date = sysdate where line_id = l_line_id; Begin select number_value into l_user_id from wf_item_attribute_values where item_type = 'OEOL' and item_key = to_char(l_line_id) and name = 'USER_ID'; select number_value into l_resp_id from wf_item_attribute_values where item_type = 'OEOL' and item_key = to_char(l_line_id) and name = 'RESPONSIBILITY_ID'; select number_value into l_resp_appl_id from wf_item_attribute_values where item_type = 'OEOL' and item_key = to_char(l_line_id) and name = 'APPLICATION_ID'; Exception When No_Data_Found Then l_wf_exists := 'N'; End; If l_wf_exists = 'Y' Then fnd_global.apps_initialize(l_user_id, l_resp_id, l_resp_appl_id); wf_engine.handleerror( OE_Globals.G_WFI_LIN , to_char(l_line_id) , 'CLOSE_LINE' , 'RETRY' , 'CANCEL' ); End If; update wsh_delivery_assignments set delivery_id = null , parent_delivery_detail_id = null , last_updated_by = -2564702 , last_update_date = sysdate where delivery_detail_id in (select wdd.delivery_detail_id from wsh_delivery_details wdd, oe_order_lines_all oel where wdd.source_line_id = l_line_id and wdd.source_code = 'OE' and oel.open_flag = 'N' and oel.shipped_quantity is null and oel.ordered_quantity = 0 and released_status <> 'D'); update wsh_delivery_details set released_status = 'D' , src_requested_quantity = 0 , requested_quantity = 0 , shipped_quantity = 0 , cycle_count_quantity = 0 , cancelled_quantity = decode(requested_quantity,0,cancelled_quantity,requested_quantity) , subinventory = null , locator_id = null , lot_number = null , serial_number = null , revision = null , ship_set_id = null , inv_interfaced_flag = 'X' , oe_interfaced_flag = 'X' , last_updated_by = -2564702 , last_update_date = sysdate where delivery_detail_id in (select wdd.delivery_detail_id from wsh_delivery_details wdd, oe_order_lines_all oel where wdd.source_line_id = l_line_id and wdd.source_code = 'OE' and oel.open_flag = 'N' and oel.shipped_quantity is null and oel.ordered_quantity = 0 and released_status <> 'D');

Exception when others then rollback; dbms_output.put_line(substr(sqlerrm, 1, 240));End;/ PromptPrompt ===========================================================Prompt You must enter COMMIT to Save changes or ROLLBACK to RevertPrompt =========================================================== spool off …………………………………………………………………………………………………………………………………………………………$ sqlplus apps/apps @single.sql SQL*Plus: Release 8.0.6.0.0 - Production on Sat Aug 13 11:11:04 2005 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to:Oracle8i Enterprise

Edition Release 8.1.7.4.0 - ProductionWith the Partitioning optionJServer Release 8.1.7.4.0 - ProductionEnter LINE_ID of the Line to Cancel : 858580Script run at Date/Time-------------------------13-AUG-2005 11:33:00===========================================================You must enter COMMIT to Save changes or ROLLBACK to Revert===========================================================SQL> commit;SQL>

<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-hansi-font-family: 'Times New Roman'; mso-bidi-f

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有