EAMPMSDU module: Generate Preventive Maintenance Work Orders fails With ExceptionPM Schedule Engine: ORA-29285 (Doc ID 1662829.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Asset Management - Version 11.5.10.2 to 12.2.3 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to run EAMPMSDU module: Generate Preventive Maintenance Work Orders for a single maintenance organization
the following error occurs.


* The last service scheduled end date is: null
ruleType is PMConstants.DAY_INTERVAL_RULE
query: select wdj.wip_entity_id,  wdj.scheduled_start_date,        wdj.firm_planned_flag,       decode(nvl(wod.pending_flag,'N'),'N',wdj.status_type,ews.system_status) status_type1,        nvl(wdj.pm_schedule_id, -1),        nvl(wod.cycle_id, -1),        nvl(wod.seq_id, -1),       wod.pm_base_meter_reading   from wip_discrete_jobs wdj, mtl_eam_asset_activities eaa, eam_work_order_details wod,eam_wo_statuses_v ews  where wdj.organization_id = :1    and wdj.primary_item_id = eaa.asset_activity_id    and wdj.wip_entity_id = wod.wip_entity_id    and wdj.organization_id = wod.organization_id    and eaa.activity_association_id = :2    and wdj.maintenance_object_id is not null    and wdj.status_type in (1, 3, 6, 17)    and wdj.maintenance_object_id = eaa.maintenance_object_id    and wdj.maintenance_object_type = eaa.maintenance_object_type    and wod.user_defined_status_id = ews.status_id     order by wdj.scheduled_start_date

* The Day interval is: 1.7976931348623157E308
*******************************************
* The Due Date is 2014-04-19 00:00:00.0
Visiting PM Node with node next PM >  false.Running Context : ConProgram >true
PMEngine.java:execute():got out of the loop
PMEngine.java:execute():almost the end
PMEngine: Execute: Everything Done. returning
ExceptionPM Schedule Engine: ORA-29285


The issue can be reproduced at will with the following steps:
1.  Enterprise Asset Management: Preventive Maintenance: Generate Work Orders
2.  Launch PM for a maintenance organization
3. Error


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms