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:
- Add a Work Order. (Navigation : Maintenance Management > Work Order Management > Work Order)
- Fill all the details for Work order and save the page.
- 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 |