Why are users receiving error 'ORA-01403 No Data Found' when creating sales orders for (ATP) Related Items? (Doc ID 1929890.1)

Last updated on JUNE 28, 2017

Applies to:

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

Goal

Why are users receiving error: ORA-01403 no data found when creating a sales order with related items?


Summary of Issue:
-----------------------
When attempting to create a sales order with a related item, users are receiving error messages.
Enter a new order for an item that has a related item, and receive the error Go to the related
items form and no data is displayed.

OBSERVATION
----------------------
The line shows up as a related item – when the related items form attempts to open we get the
ORA-01403: No Data Found. Add Item to order line (item and item description are red.. indicating
a related item exists) This is reproducible for all related items.

If you look at the Item Relationships:
From Item: 1062607 > To Item: 1088356 > Type = Related

*Users are getting errors and cannot process order lines for related items. When they review the related
items form there is no data. However, if you go to the Item Relationships setup the relationship is valid
and active.
 

Solution

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