My Oracle Support Banner

UPDATE_USER & UPDATE_DATE Not Being Set For 'Item Attribute Value' And 'Item Attribute Qualifier ID' Update in ITEM_FEATURE Table (Doc ID 2524471.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Global Trade Management - Version 6.4.2 and later
Information in this document applies to any platform.

Symptoms

OTM/GTM does not update the UPDATE_USER & UPDATE_DATE columns in the item_feature table when modifying the 'Item Attribute Value' and 'Item Attribute Qualifier ID' on the Trade Item's 'Features' tab.

Example:
-----------

01. Create an OTM Item or a GTM Trade Item: TEST_ITEM

02. Edit -> Go to "Features" tab -> Add the following

Item Attribute Value: GREEN
Item Attribute Qualifier ID: TYPE

Save and Finish

24:18.8 793865 Debug Sql insert into item_feature (item_gid,item_feature_qual_gid,item_feature_value,effective_date,expiration_date,domain_name) values (?,?,?,?,?,?);
http://<DOMAIN_NAME>.3-TEST_ITEM, TYPE, GREEN, null, null, <DOMAIN_NAME> [

24:18.9 793865 Debug Sql update item set update_date = sysdate where item_gid = ?; http://I<DOMAIN_NAME>.3-TEST_ITEM txComplete - 1

select * from item_feature where item_gid='<DOMAIN_NAME>.3-TEST_ITEM'

UPDATE_USER: NULL
UPDATE_DATE: NULL

select * from item where item_gid='<DOMAIN_NAME>.3-TEST_ITEM'

UPDATE_USER: <DOMAIN_NAME>.ADMIN
UPDATE_DATE: 2019-03-21 21:22:53.0

03. Edit and update the Item Feature

Item Attribute Value: RED
Item Attribute Qualifier ID: TYPE

34:58.1 857797 Debug Sql insert into item_feature (item_gid,item_feature_qual_gid,item_feature_value,effective_date,expiration_date,domain_name) values (?,?,?,?,?,?);
http://I<DOMAIN_NAME>.3-TEST_ITEM, TYPE, RED, null, null, <DOMAIN_NAME> [

34:58.1 857797 Debug Sql update item set update_date = sysdate where item_gid = ?; http://<DOMAIN_NAME>.3-TEST_ITEM txComplete - 1

select * from item_feature where item_gid='<DOMAIN_NAME>.3-TEST_ITEM'

UPDATE_USER: NULL
UPDATE_DATE: NULL

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


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