My Oracle Support Banner

EMM: Performance Issue For WM_CLOSE Process On The Step WMCLSUPDTPC.UPDTDTTM.LOOPASST (Doc ID 2972826.1)

Last updated on NOVEMBER 09, 2023

Applies to:

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

Symptoms

WM_CLOSE process is taking a long time on the SQL below step, WMCLSUPDTPC.UpdtDttm.LoopAsst.



Do-Select SQL
-------------------
%SelectInit(WM_CLSDTTM_AET.BUSINESS_UNIT_AM,WM_CLSDTTM_AET.ASSET_ID,WM_CLSDTTM_AET.BUSINESS_UNIT,WM_CLSDTTM_
AET.WO_ID,WM_CLSDTT_AET.WO_TASK_ID,WM_CLSDTTM_AET.MAINT_DTTM)
SELECT BUSINESS_UNIT_AM
, ASSET_ID
, BUSINESS_UNIT
, WO_ID
, WO_TASK_ID
, TO_CHAR(CAST((MAINT_DTTM) AS TIMESTAMP)
,'YYYY-MM-DD-HH24.MI.SS.FF')
FROM PS_WM_WOCLS_TAO
WHERE PROCESS_INSTANCE = %ProcessInstance
AND BUSINESS_UNIT_AM = %Bind(BUSINESS_UNIT_AM)
AND ASSET_ID = %Bind(ASSET_ID)

SQL
--------
UPDATE PS_WM_WOCLS_TAO
SET MAINT_DTTM = %Bind(WM_CLSDTTM_AET.MAINT_DTTM)
WHERE PROCESS_INSTANCE = %ProcessInstance
AND BUSINESS_UNIT = %Bind(WM_CLSDTTM_AET.BUSINESS_UNIT)
AND WO_ID = %Bind(WM_CLSDTTM_AET.WO_ID)
AND WO_TASK_ID =%Bind(WM_CLSDTTM_AET.WO_TASK_ID)



Replication Steps:

  1. Add a Work Order. (Navigation : Maintenance Management > Work Order Management > Work Order)
  2. Fill all the details for Work order and save the page.
  3. Close the Work Order ( Navigation : Maintenance Management > Work Order Management > Work Order Processing > Close Work Order)

     

     

 



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.