My Oracle Support Banner

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 AUGUST 30, 2021

Applies to:

Siebel Preventive Maintenance - Version 20.5 and later
Information in this document applies to any platform.

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:

e.g:

Interval: 1
Valid Start: 0
Valid End: 2


Add Usage
Type: Cycle Counter
Interval: 1
Valid Start: 0
Valid End: 2

Add threshold:
Type: Cycle Counter



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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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