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 AUGUST 02, 2017

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.

Symptoms

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:

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

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


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