csitneru.sql running very slow during 12.1.1 upgrade driver

Hi

I am using Sept 2013 zip file off MOS Note:

1448102.1

 

The upgrade driver was running fine until script csitneru.sql and this script is running for ever. Below is the sql causing performance problem.

SELECT /*+ INDEX(mmt MTL_MATERIAL_TRANSACTIONS_U1)*/ MMT.TRANSACTION_ID, MMT.TRANSACTION_SOURCE_TYPE_ID, MMT.TRANSACTION_TYPE_ID, MMT.TRANSACTION_ACTION_ID, MMT.TRANSACTION_QUANTITY, CTE.TRANSACTION_ERROR_ID, MMT.SHIP_TO_LOCATION_ID FROM MTL_MATERIAL_TRANSACTIONS MMT, CSI_TXN_ERRORS CTE WHERE CTE.INV_MATERIAL_TRANSACTION_ID IS NOT NULL AND MMT.TRANSACTION_ID = CTE.INV_MATERIAL_TRANSACTION_ID AND CTE.PROCESSED_FLAG IN ('E','R')