EMM: WM/PM Process Creating Work Orders With Negative Work Order ID's (Doc ID 2247944.1)

Last updated on MARCH 24, 2017

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, PI # 21. Preventive Maintenance

WM/PM Process creating work orders with negative work order ID's

WM/PM Process creating work orders with negative work order ID's. The WM/PM process received a duplicate key row error when inserting in PS_WM_PM_ACT_INST table. However the process completed "successfully", but the work orders had negative ID's. The PM processes for other business units that ran after this PM process also had negative work order ID's.

 
 

ERROR
-----------------------

SQL error. Function: SQLExec Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key r ow in object 'dbo.PS_WM_PM_ACT_INST' with unique index 'PS_WM_PM_ACT_INST'. The duplicate key value is (5002). Statement: INSERT INTO PS_WM_PM_ACT_INST (RUNDTTM, INTFC_ID, TO_INTFC_ID, RUNDATE) VALUES (GETDAT E(), :1 , :2, { FN CURDATE() }) Original Statement: INSERT INTO PS_WM_PM_ACT_INST (RUNDTTM, INTFC_ID, TO_INTFC_ID, RUNDATE) VALUE S (%CURRENTDATETIMEIN, :1 , :1, %CURRENTDATEIN)
10 6:11:06AM 441 Row(s) Processed
10 6:11:26AM 435 work order(s) created
10 6:11:29AM Process ended with success



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a PM schedule
2. Run WM_PM process to create WO's.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have created WO's correctly.

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