Unexpectedly high number of rows in the YFS_ORDER_DATE or YFS_ADDITIONAL_DATE database tables

You might notice that you have an unexpectedly high number of rows in the YFS_ORDER_DATE or YFS_ADDITIONAL_DATE database tables. The high number of rows might not impact performance but the extra rows can cause unnecessary processing.

Problem

Milestone entries were added in the YFS_STATUS_MILESTONE table to use as status options when creating Alert rules.

As a result, the Sterling™ Order Management System created applicable entries in the YFS_ORDER_DATE table for all orders and entries in the YFS_ADDITIONAL_DATE table for all shipments.

Solution

If you are not using alert rules, or are not using some of the default milestones, it is recommended that you remove these milestones to avoid the database overhead of creating database entries in the YFS_ORDER_DATE or YFS_ADDITIONAL_DATE tables.

To delete order milestones:
  1. Log in to Applications Manager and select Applications > Distributed Order Management. For more information about Applications Manager, see Starting the Applications Manager.
  2. In DOM (DEFAULT), expand Distributed Order Management > Document Specific > Sales Order > Fulfillment.
  3. Right-click Order Monitoring and select Details.
  4. Click the Milestones tab.
  5. For each milestone that you want to delete, complete the following steps:
    1. Right-click the Milestone and select Details.
    2. Select the Milestone Statuses tab.
    3. Delete the entries from the Milestone Status List.
    4. Save the Milestone Details.
    5. Select and delete the Milestone.
To delete shipment milestones:
  1. Log in to Applications Manager and select Applications > Distributed Order Management. For more information about Applications Manager, see Starting the Applications Manager.
  2. In DOM (DEFAULT), expand Distributed Order Management > Document Specific > Sales Order > Outbound Logistics.
  3. Right-click Shipment Monitoring and select Details.
  4. Click the Milestones tab.
  5. For each milestone that you want to delete, complete the following steps:
    1. Right-click the Milestone and select Details.
    2. Select the Milestone Statuses tab.
    3. Delete the entries from the Milestone Status List.
    4. Save the Milestone Details.
    5. Select and delete the Milestone.