oracle erp 选择会错行,Oracle erp销售订单订单行状态不对导致订单无法关闭之解决方案！...

销售订单行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' ;

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;