My Oracle Support Banner

EMM: Saving a Closed Work Order Updates the LAST_UPDATE_DTTM and the LAST_UPDATED_BY Values on the PS_WM_WO_HDR Table (Doc ID 3018235.1)

Last updated on APRIL 22, 2024

Applies to:

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

Symptoms

Saving a Closed Work Order updates the LAST_UPDATE_DTTM and the LAST_UPDATED_BY values on the PS_WM_WO_HDR table
Expecting the PS_WM_WO_HDR.LAST_UPDATE_DTTM value to remain unchanged


The issue can be reproduced at will with the following steps:

1. Navigate to Maintenance Management > Work Order Management > Work Order
2. Identify a Work Order that is in a Closed "WO Status"
3. Review the LAST_UPDATE_DTTM and the LAST_UPDATED_BY values on the WM_WO_HDR table.
4. Click on the Save button without performing any changes.
5. Review the WM_WO_HDR, notice that the LAST_UPDATE_DTTM and the LAST_UPDATED_BY was updated.
 

Detailed DEMO Replication Steps Attached

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
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.