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 JULY 20, 2024
Applies to:
Oracle Global Trade Management - Version 6.4.2 and laterInformation 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 |