My Oracle Support Banner

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


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.