My Oracle Support Banner

Booking Order Errors With Unable To Schedule WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS ORA-01403 (Doc ID 757108.1)

Last updated on JANUARY 03, 2023

Applies to:

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


Symptoms

When attempting to book orders the following errors occurs:

Unexpected Error: Error in Routine WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS, Oracle Error - 100 ORA-01403: no data found

Error: Failed to import the order line because Create_Delivery_Details failed.

Workflow activity Ship has failed.

Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.


Steps To Reproduce:
1. Order Management Super User
2. Orders, Returns > Sales Orders
3. Enter Sales Order
4. Enter Sales Order Line (Item, Qty, Unit Selling Price, Request Date, Schedule Ship Date)
5. Book Sales Order
6. Receive the error messages

Changes

Upgraded from RUP4 to RUP6.

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

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