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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.