IBM Support

Running manageItem API creates new records in yfs_additional_attribute table

Troubleshooting


Problem

Attempts to run manageItem API creates new records in yfs_additional_attribute table in IBM Sterling Order Management

Symptom

Use the following input to manageItem API to modify attribute value:

<AdditionalAttributeList>
           <AdditionalAttribute AttributeDomainID="DomainAttribute" AttributeGroupID="GroupAttributes"
               Operation="Manage" Name="ItemDescription" Value="TEST"/>
       </AdditionalAttributeList>
   </Item>
When you give this for the first time, the item gets created with the attribute value=TEST for the Name = ItemDescription.
If you send a delta item feed xml, which has value = TESTUPDATED for the same Name=ItemDescription, the system is not overriding the value in the yfs_attribute table for the attribute ItemDescription. It instead created multiple records in yfs_additional_attribute table for the same attribute.
 

Cause

You want to update the values of the attribute and not create another additional attribute

Resolving The Problem

Set the property yfs.manageItem.EnableUpdateOfAdditionalAttribute=Y. Refer Catalog Management yfs.properties for more information.

Related Information

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Documentation","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.2.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
10 May 2022

UID

swg21666200