My Oracle Support Banner

OEXOETEL Quick Sales Order: ORA-01403: No Data Found In Package Oe_Oe_Form_Line (Doc ID 2198940.1)

Last updated on AUGUST 09, 2021

Applies to:

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


Receiving ORA-01403 error when we add a new line to an order where a promotional modifier (Buy and GET) is applied.

'ORA-01403: no data found in Package Oe_Oe_Form_Line procedure Change_Attribute'

The issue can be reproduced at will with the following steps:
1: Enter a sales order line for Item IM4D with a quantity of 1 and save
2: BAG modifier -'DELIVERY - FEDEX - BAG' get applied and the system adds a new line item 'SMALL PACKAGE DELIVERY' with a price of 6.5 --OK
3.Add another order line for same item IM4D with a quantity of 10 and save.
4: We expect that system recalculates the weight for both the lines and should change the price as per the new weight. This is not happening and system throws an error message 'ORA-01403: no data found in Package Oe_Oe_Form_Line procedure Change_Attribute'



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

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