My Oracle Support Banner

* ORA-01403: No Data Found In Package OE_Holds_Pvt Procedure Create_Order_holds (Doc ID 2186342.1)

Last updated on AUGUST 30, 2022

Applies to:

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

Symptoms

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

ERROR

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

STEPS TO REPRODUCE

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

Changes

 Upgrade from 11i to 12.2.5.

Cause

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
Symptoms
Changes
Cause
Solution
References


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