EMM: Doing EX_TRAN_PRWM And PC_EX_TO_PC Before WM_CLOSE Still Not Closing All CMPL WOs In MM (Doc ID 2150265.1)

Last updated on JULY 11, 2016

Applies to:

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

Goal

EX_TRAN_PRWM and PC_EX_TO_PC are not currently being run in the Production environment. Most Work Orders still are successfully closed without those processes (377K Closed WO's vs 43K CMPL WOs).

It has been determined that a SQL update of WM_WO_SCHED_LBR.ACTL_RESOURCE_CD to a ' ' value for any WO with WM_WO_HDR.STATUS_CD = 'CMPL' enables the successful closing of ninety plus percent of the unclosed CMPL WO's.

Is there a process to be run without resorting to a SQL update of the WM_WO_SCHED_LBR.ACTL_RESOURCE_CD that enables the PSFT application itself to Close these WO's?
Why does eliminating the 'W' from the ACTL_RESOURCE_CD field enable Closing the WO?
 

Solution

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