Run Data Conversion AE - DCTR25180418 running 15hrs +, Please help and suggest on the same
1) We are doing PUM Update from PUM 5 TO 35.
2) As part of the Image update Change Package (MTP) There is step (Run Data Conversion AE - DCTR25180418 )
3) As part of Data Conversion AE - DCTR25180418 , Below is the update Sql which is running more than 20+hrs
Run Data Conversion AE - DCTR25180418
======================================
UPDATE PS_BANK_STMT_TBL SET TRAN_LINE = 1 + ( SELECT COUNT(1) FR
OM PS_BANK_STMT_TBL B WHERE B.BNK_ID_NBR = PS_BANK_STMT_TBL.BNK_
ID_NBR AND B.BANK_ACCOUNT_NUM = PS_BANK_STMT_TBL.BANK_ACCOUNT_NU
M AND B.RECON_CYCLE_NBR = PS_BANK_STMT_TBL.RECON_CYCLE_NBR AND B