My Oracle Support Banner

"ORA-01403: No data found" Error is Raised When An Order Line is Created With Quantity That Exceeds An Existing Sales Agreement Maximum Quantity Agreed (Doc ID 2630431.1)

Last updated on JANUARY 19, 2020

Applies to:

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

Symptoms

On : 12.2.8 version, Transaction Entry

When attempting to create a sales order with an order line quantity that exceeds an existing sales order agreement, the following error occurs.

ERROR
-----------------------
Total released quantity exceeds maximum quantity (Sales agreement UOM: __ Max Agreed: ##) on the sales agreement line. Sales agreement number: #### Sales agreement line: #

Later when navigating to the header and back to lines, the following error occurs:
ORA-01403: No data found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Order Management responsibility
2. Sales Agreement form
3. Create a new sales agreement for this customer and item with quantity 10
4. Sales Order form
5. Create a new order for this customer
6. Create an order line with quantity higher than 10, such as 20 for the above mentioned line
7. Error occurs

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