My Oracle Support Banner

Cancelling Internal Order Line Is Successful Yet Related Delivery Detail Is Not Cancelled And Error ORA-01086: Savepoint 'UPDATE_REQCANCEL_FROM_SO_SP' Never Established In This Session Or Is Invalid Is Raised In Debug (Doc ID 1373980.1)

Last updated on OCTOBER 11, 2023

Applies to:

Oracle Order Management - Version 12.1.3 and later
Oracle Shipping Execution - Version 12.1.3 and later
Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


When a line in an internal order is canceled, the related delivery detail line does not get cancelled.
The following error is seen in the debug log:


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.