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

(Doc ID 1373980.1)

Last updated on AUGUST 02, 2017

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 ***

Symptoms

On : 12.1.3 version,

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

EXPECTED BEHAVIOR
-----------------------
The Delivery line to be cancel when the order line is canceled

ERROR
----------
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


STEPS
-----------------------
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.

Cause

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