OEXOETEL Quick Sales Order: ORA-01403: No Data Found In Package Oe_Oe_Form_Line
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.
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'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms