Question & Answer
Question
reserveItemInventory Api and its lock on YFS_INVENTORY_ITEM table
Answer
reserveItemInventory Api locks YFS_INVENTORY_ITEM though there are no
updates made to this table.The table is locked even if inserts are made.We are
locking the yfs_inventory_item table although no updates are being made as
otherwise when looking up inventory for the item, more than one api may look at
the inventory and make a dirty read.
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
FAQ3379
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21518763