IBM Support

Inventory activity records not created in Sterling Order Management

Troubleshooting


Problem

Attempts to load inventory do not create inventory activity records in IBM Sterling Order Management.

Symptom

Steps to reproduce:

  1. Load the item inventory

  2. Calling sync load inventory.
    Sterling is not creating inventory activity records.

This is causing out of sync issues with front end website leading to oversells, incorrect orders and hence not able to fulfill the demand.

Diagnosing The Problem

This is a 3 step process - Load, Sync, Adjust.

adjustInventory creates activities. Load will have the snapshot details. Sync will compare that snapshot (from temp table) with what's there in supply table and sync will raise event(s) for the differences.
These events will call adjustInventory. adjustInventory will make the adjustment of the difference and create activity.
Only if item is being monitored, it will create activity
If item is monitored at node or network level, activity will be created

Resolving The Problem

For the node. On item, Set monitor rule that should be used for network or node level (or both).
If either one of these are set, product will create activity only if activity doesn't already exist.

In the logs check for YFS_INVENTORY_ACTIVITY records. If you see select for YFS_INVENTORY_ACTIVITY and no insert, this means activity was already there. If you do not see select, it may mean that item has not been configured to do monitoring.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Documentation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF034","label":"Windows Mobile"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
10 May 2022

UID

swg21688540