In Internal Order after Canceling a Line the Associated Delivery Line Is not cancelled

(Doc ID 1373980.1)

Last updated on JANUARY 05, 2018

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance on 16-Jun-2015 ***


On : 12.1.3 version,

When a line in an internal order is canceled, the Delivery line is not canceled

The Delivery line to be cancel when the order line is canceled

The Cancellation Debug file shows the following error:
When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition ORA-01086: savepoint 'UPDATE_REQCANCEL_FROM_SO_SP' never established in this session or is invalid
ORA-01086: savepoint 'UPDATE_REQCANCEL_FROM_SO_SP' never established in this session or is invalid
ORA-06512: at "APPS.PO_RCO_VALIDATION_PVT", line 6076
ORA-06510: PL/SQL: unhandled user-defined exception

The issue can be reproduced at will with the following steps:
1. Process an internal requisition
2. Have an Internal Order
3. Cancel one or more order lines
4. Notice the corresponding delivery lines are not canceled
5. If a debug is created, it shows the PO error.

Also,  users may experience an error message WSH_PICK_LIST_EXCEPTION when subsequently attempting to pick release all eligible orders/delivery details.   This happens because the delivery detail is still open and eligible for pick release when the order line is closed.  Please see <Note 1291007.1> for more information on this issue.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms