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 MARCH 28, 2019

Applies to:

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

Symptoms


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

STEPS
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
- 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 back end table

Run the query
select *
from ONT_GSAM_PRICE_AGV
where line_id in ( x,xx,xxx)
  order by line_id desc

Value Returned for Line_Id = 1234
--------------------------------------------------------
Extension_ID Line_ID Data_Level_ID GSAM_Price
123 123456 12345 99.99 (for example)


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.