In other words you can use the Preventive Maintenance to schedule the automatic generation of work orders.
Work orders can be generated manually using the 'Generate Work Orders' action in the Preventive Maintenance application. A dialog will be displayed allowing to set the number of days in the future for which the work orders must be created.
The work order generation can be easily automated using the PMWoGenCronTask cron task.
Once the cron task schedule is set you can specify the PM generation rules for each site. Open the Organization application, pick your organization and select the 'PM Options' action from the menu.
The following dialog will be displayed allowing to set the generation option for each site.
Processing all the PM records each day to generate few work orders is not the best option. Almost all the processed records will generate a warning like this:
BMXAA3191E - PM XXXXX is not due yet, or it does not fall within the active season.
A good practice is to restrict as much as possible the PM records processed using the where clause. For example the following where clause selects only the active PM records that will generate a work order in the next month.
status='ACTIVE' and nextdate - NVL(leadtime,0) - 30 <= SYSDATE
This is important to lower PM generation workload and to avoid a long list of warning messages in the logs.
Using Preventive Maintenance (PM) Records to Create Work Orders
Executing PM Wogen Crontask by Site