Deleting Lines In OM Does Not Delete Record In User Defined Attributes 'UDA' Tables (Doc ID 1988246.1)

Last updated on JULY 27, 2016

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

On : 12.2.3 version,

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
- 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 *
from ONT_GSAM_PRICE_AGV
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


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