EMM: The Preventive Maintenance (PM) Schedule Projection is not correct if a Business Calendar Id is specified in the PM Options for the WO BU (Doc ID 2004860.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

If a Business Calendar is specified in the the Maintenance Management Work Order Business Unit Preventive Maintenance Options page, there are errors when the Run Projection process is executed.
For example:
1) Preventive Maintenance Schedule, Run Projection takes account of the Business Calendar when, in the Work Order Business Unit Preventive Maintenance Options, the Calendar id. field is populated and "Use business day" is NOT selected.
2) If "Use business day" and "Next business day" are selected in the WO BU PM Options, and the Business Calendar causes a due date to be moved to the following month, then the due date for that following month is skipped.  
3) If the PM Schedule is Date Based, Monthly by Date: 15th and the WO BU PM Options are "Use business day" and "Next Business Day" or "Prior Business Day", then the first due date is the day the projection was run, not the 15th of the month. All other due dates are correct.
4) if the PM Schedule is Date Based, Monthly by Date: 1st and the WO BU PM Options are "Use business day" and "Prior Business Day, then the PM Projection process fails with the following error:
SQL error. Stmt #: 1623  Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_WM_PM1_TAO6) violated
Failed SQL stmt: UPDATE PS_WM_PM1_TAO6 SET NEXT_DUE_DT = TO_DATE('2014-05-30','YYYY-MM-DD') , VALIDATE_DT = 'N' , DUPLICATE_FLG = 'N' WHERE PROCESS_INSTANCE = 497906 AND NEXT_DUE_DT = TO_DATE('2014-06-01','YYYY-MM-DD') AND HOLIDAY_LIST_ID = '01' AND NEXT_DUE_DT <> TO_DATE('2014-05-30','YYYY-MM-DD') AND PM_CALC_TYPE NOT IN ('2' , '4', '5')
Process ABENDED at Step WM_PM_LBR.UPDNXTDT.WRKDAY (SQL) -- RC = 805 (108,524)

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