My Oracle Support Banner

OEXOEORD :Error Frm-40222 Disabled Item 'line.Ship_to_location' Failed Validation While Deleting Model Item from Sales Order Line Form (Doc ID 2076202.1)

Last updated on JANUARY 07, 2022

Applies to:

Oracle Order Management - Version 12.1 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.


When attempting to delete a model item line in ENTERED status which has more then 7 child lines  from Sales order lines block using Delete icon an additional line  appears with partially filled fields and the following error occurs:

User-Defined Exception
FRM-40222 Disabled item 'LINE.SHIP_TO_LOCATION' failed validation
FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-01403.
ORA-01403: no data found
ORA-01403: no data found
ORA-06512 at "APPS.OE_LINE_UTIL"'line 12341
ORA-01403: no data found in package Oe_Oe_Oe_Form_Line
Procedure Change_Attribute

The issue can be reproduced at will with the following steps:
1. Log Into the Order Management Responsibility
2. Navigate to Sales orders, Returns> Sales orders
3. Open The Sales order Form and query the Order with ATO /PTO Model which is in ENTERED status.
4. Go the Model order Line and Delete the Line using Delete Icon.


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.