Siebel Field Service Guide > Preventive Maintenance > About the Preventive Maintenance Engine >

Guidelines for Improving Performance of the Preventive Maintenance Engine


This topic provides guidelines for improving the performance of the Preventive Maintenance Engine.

Use the following guidelines to improve this performance:

  • Use the Asset SQL parameter more often than the Plan SQL parameter or Agreement SQL parameter.

    The Asset SQL parameter is the most direct way to specify the assets for which the PM Engine creates PM actions. The Asset SQL parameter directly retrieves the assets.

    When evaluating the Plan SQL parameter, the PM Engine must first review the PM plans to find the corresponding assets. In this process, the PM Engine also evaluates the All Assets check box.

    When evaluating the Agreement SQL parameter, the PM Engine must first review the agreements to find the entitlements and the corresponding PM plans. In this process, the PM Engine also evaluates the All Contacts check box and All Products check box in the entitlements. Then, the PM Engine must review the found PM plans to find the corresponding assets. In this process, the PM Engine also evaluates the All Assets check box.

  • Restrict the search criteria in the parameters when you use the Asset SQL, Plan SQL, and Agreement SQL parameters.
  • Delete all records from the S_PM_ACTION table.

    The PM Engine does not have to check for prior actions.

Siebel Field Service Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.