patch for bug 5397515 or alternate for query please
Hi
I am running following query on 10.2.0.3 but giving me internal error. Came to know that its a bug 5397515 fixed in 10.2.0.4. I want to know is there any patch available to resolve just this bug without shifting to 10.2.0.4. or any alternate for this query please??
SELECT AB.SHIPMENT_LINE_ID, AB.TRANSACTION_ID
FROM RCV_TRANSACTIONS AB
WHERE AB.TRANSACTION_TYPE = 'RECEIVE'
AND AB.SHIPMENT_LINE_ID NOT IN
(select
RTS.SHIPMENT_LINE_ID
from RCV_TRANSACTIONS RTS
WHERE (LEVEL = 2 OR
LEVEL =
(
select MAX(LEVEL)
from RCV_TRANSACTIONS B
start with B.TRANSACTION_ID = 133847
connect by PRIOR B.TRANSACTION_ID = B.PARENT_TRANSACTION_ID))