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 SEPTEMBER 20, 2017

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.