IBM Support

When does a record get written to the YFS_INVENTORY_AUDIT table?

Troubleshooting


Problem

When does a record get written to the YFS_INVENTORY_AUDIT table?

Symptom

PART: Platform 3.1 SP2 Platform
COMPONENT: <None>
OS: <None> - <None>
DATABASE: <None> - <None>
WEB SERVER: <None> - <None>
WEB BROWSER: <None> - <None>

Cause

Resolving The Problem

The only quantity fields in the YFS_INVENTORY_AUDIT table are ON_HAND_QTY and ON_HAND_HELD_QTY. Only those transactions that cause either of these quantities to change will write records into the Audit table. Examples of such transactions are receipts, shipments, and adjustments.

An event such as Order Allocation will not cause a record to get created in the Audit table since there is no change to either the ON_HAND_QTY or the ON_HAND_HELD_QTY fields.

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

PRI48052

Product Synonym

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

Document Information

Modified date:
16 June 2018

UID

swg21535031

Page Feedback