IBM Support

Can we delete zero quantity records in yfs_inventory_demand table?

Troubleshooting


Problem

Can we delete zero quantity records in yfs_inventory_demand table?

Symptom

PART: Platform-Config 5.0 SP4 Platform
PRODUCT: Distributed Order Management
COMPONENT: Users
OS: Solaris - 2.8
DATABASE: Oracle - 9.2.0.4
WEB SERVER: WebLogic - 8.1 SP2
WEB BROWSER: Internet Explorer - 6.0 sp1

Can we delete zero quantity records in yfs_inventory_demand table?

Cause

Resolving The Problem

The answer is yes, they tried in 5.0sp2 and it worked fine after that.
One caveat is that you should delete associated records in yfs_inventory_demand_addnl and yfs_inventory_demand_dtls.

[{"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

PRI49362

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21536994