* 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

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