Preventive Maintenance Engine Generates A Query To Select All Assets for All PM Plans Associated To The Asset (Doc ID 2803310.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Preventive Maintenance Engine takes a long time to complete.

In a scenario where 500 Assets are processed daily, for each asset 6 Service Requests are created, this process will run for 7 to 8 hours.

This is observed when PM Component Parameter "Mode" is set for 'Asset' or 'Id' (Please refer to Siebel Field Service Guide > Preventive Maintenance  > Parameters for the Preventive Maintenance Engine)


The issue can be reproduced at will with the following steps:

1) Go to Preventive Maintenance > PM Plans

2) Create 4 PM Plans

3) Drilldown and Add Time Interval, Usage and Threshold as needed:

4) In the Products tab, add 1 Product and 1 Asset

5) Go to Actions and add an SR Template and Activity Templates
(SR Templates are created under Administration - Service > SR Templates)

6) Go back to Preventive Maintenance> Products and drilldown in Assets

7) Click in "Run PM" button

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.