Unable To Cancel Internal Orders (Doc ID 1638199.1)

Last updated on JUNE 24, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
*** Currency Check 24-Jun-2016 ***

Symptoms

On : 12.1.3 version, Trx Changes & Cancellations

When attempting to cancel internal sales order the following error occurs. If users tries
to cancel the Internal Sales Order no error occurs, however, Oracle just freezes and will
not move forward when we click OK.

But when we tried to make the quantity on Sales Order Line to 0 then we got this error in
Production 'ORA-1403 No Data found in package OE_LINE_UTIL_PROCEDURE UPDATE_ROW'.
Note: Company cannot replicate this error in TEST instance.

OBSERVATION
Actions --> Cancel function is not working for us for Internal Sales Orders.
Oracle freezes and will not move forward if we enter a reason and click on Ok.
The company had quarterly patching last weekend after which users are not
able to cancel Internal Sales Orders.

ERROR
 'ORA-1403 No Data found in package OE_LINE_UTIL_PROCEDURE UPDATE_ROW'
(Based on this error message thus the reason for referencing Note.16084651.)


STEPS
1. Responsibility: Order Management Super User
2. Order Organizer > Query Sales Order = 2091293
3. Line 1.1 > Actions > Cancel > Cancel Reason
4. System does not allow user to cancel internal sales order line

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