Cancel Internal Sale Order Fails in Purchasing Code and Delivery Line Is Not Canceled

(Doc ID 2284209.1)

Last updated on JULY 29, 2017

Applies to:

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


While cancelling the Internal Sale Order line, delivered line is not cancelled and the following error is visible in front end:

ORA-01086: savepoint 'UPDATE_REQCANCEL_FROM_SO_SP' never established in this session or is invalid
ORA-06512: at "APPS.PO_RCO_VALIDATION_GRP", line 860
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 7079
ORA-06510: PL/SQL: unhandled user-defined exception in PAckage OE_PROCESS_REQUISITION_PVT Procedure Update_Internal_Requisition


Steps to reproduce:

1. Go in Order Management responsibility
2. Choose Orders, Returns-> Order Organizer-> query sale order-> Lines tab
3. Choose Actions button->Cancel
4. The error is occurring



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