* ORA-01403: No Data Found In Package OE_Holds_Pvt Procedure Create_Order_holds

(Doc ID 2186342.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

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


After upgrading to R12.2.5, when attempting to apply a hold,
the following error occurs.  The same hold worked without error in 11i.


ORA-01403: no data found in Package OE_Holds_Pvt Procedure Create_Order_holds


1. Order Management Responsibility
2. Sales Orders > Query Order
3. Apply the hold & receive the error.

The hold setup is:
Name = Manual Credit Hold
Description = Manual Credit Hold
Type = Credit Check
Workflow Item = OM Order Header
Workflow Activity = Book Order


 Upgrade from 11i to 12.2.5.


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