Deleting Lines In OM Does Not Delete Record In User Defined Attributes 'UDA' Tables

(Doc ID 1988246.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.
*** Currency Check *** 27-Jul-2016


On : 12.2.3 version,

When Delete line in OM does not delete record in UDA table.

Responsibility: Order Management Super User
Quick Sales Order Form
Create a new sales order
Enter required header information
Enter required Line information for Line 1.1
Actions > User Defined Attributes (UDA) > OK
Set a UDA value
- Good Sam Price = 99.99
- Apply
Delete the Line from the front end
Save the record
Run the above query below >>>> Observation: You still see the record in the backend table

Run the query
select *
where line_id in ( 94875,94783,94787)
  order by line_id desc

Value Returned for Line_Id = 95956
Extension_ID Line_ID Data_Level_ID GSAM_Price
630 95956 66002 99.99


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