Real-time inventory availability monitor for ATP efficiency

The Real-Time Inventory Availability Monitor is used to alert external systems when inventory availability crosses predefined thresholds. When items are flagged for real-time availability monitoring, a record is inserted into the YFS_INVENTORY_ACTIVITY table by inventory transactions that update supply or demand information. It is recommended that you enable velocity calculation to determine the inventory activities to be processed in a timely manner. You can also set the buffer for real-time availability monitor to process demand or supply activities.

This monitor checks inventory availability that is based on information in the YFS_INVENTORY_ACTIVITY table. The activity records associated with an item are deleted after the inventory check.

If you plan to use the real-time inventory availability monitor, we suggest you start with 5 threads and monitor the number of records in the YFS_INVENTORY_ACTIVITY table. It is highly recommended that you aggressively monitor the YFS_INVENTORY_ACTIVITY table. Additionally, we also recommend that you set this agent to be auto triggered with an interval of 5 minutes.

The following query can be used to monitor build up in the YFS_INVENTORY_ACTIVITY table. This query tells you the oldest activity record in the table:

   select sysdate, min(inventory_activity_key) "Min Datetime"
   from yfs_inventory_activity
   
   SYSDATE                     Min Datetime
   12/22/2011 3:57:57 PM          20111222155659187360102 
   

In the example above, the query was issued at 15:57:57 and the oldest inventory activity record was created at 15:56:59. Therefore, the monitor is keeping up by about 1 minute.

If the time gap between the current time and the oldest record keeps increasing over time, we recommend starting additional JVMs of this agent.

Note: Although described as 'real-time', availability changes may not be triggered immediately as inventory changes occur if the agent has a backlog of messages to process. Furthermore, this monitor exists as a time-triggered transaction, and thus monitors availability of inventory items only when the monitor is triggered based on the configured runtime properties.