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.