销售订单单行状态不对订单不关闭的处理,PCTFREE,性能调优
销售订单行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 Metalink
REM $Header: single.sql 115.0 2000/06/15 01:55:37 ysinha noship $
WHENEVER SQLERROR EXIT FAILURE ROLLBACK.
set ver off
set feed off
set serveroutput on size 500000
Prompt
accept order_line_id number prompt Enter LINE_ID of the Line to Cancel :
spool &.order_line_id
col dtime format a25 heading Script run at Date/Time .
0select 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
0update 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_0updated_by = -2564702
, last_0update_date = sysdate
where line_id = l_line_id.
Begin
0select 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 .
0select 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 .
0select 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 .
相关文章
销售订单单行状态不对订单不关闭的处理
ORACLE问题,每天10问(五)
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛