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

Last updated on NOVEMBER 29, 2016

Applies to:

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

Symptoms

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



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


STEPS
-----------------------
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'

 

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