Recently someone asked
They have order which have 5 lines, 2 lines we shipped and invoiced successfully , remaining 3 lines accidently cancelled and order is also closed.
Now Business has need to Ship and fulfill those 3 lines that got cancelled accidently, business don't want to create New Order.
Solution - Though Not supported by Oracle , reason - we need to do an update on OE_ORDER_HEADERS_ALL table.
OPTION # 1
Once an Order is Closed it is not advisable to open the Order because Work flow is closed and open Flag = N, so good idea is to let this order closed and create a New Order.
OPTION # 2
Open the Order by setting open-flag = Y , but do not do any thing with workflow , let it be close ,Now add new lines to the Order , and then progress the newly created lines, at any moment of time , please not try to open the lines that are accidently closed , believe me that will be very messy .
Option #2 is advisable only and only if you don't have header level invoicing , but if you have header level invoicing then do not try to open the Order header .
Once New lines are shipped and close we need to set the OPEN_FLAG= N at the Order Header Level manually again , as system will not close the Order header ( reason , workflow is already closed).