11i Uninvoiced Receipt Report Performance Issue (Doc ID 2091928.1)

Last updated on DECEMBER 23, 2015

Applies to:

Oracle Purchasing - Version 11.5.10 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On : 11.5.10 version, Accounting related

ACTUAL BEHAVIOR 
Uninvoiced Receipt report runs has the performance issue and runs for long time. 

EXPECTED BEHAVIOR

Expect Uninvoiced Receipt report to complete in few seconds. 

STEPS TO REPRODUCE THE ISSUE

The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing responsibility 
2. Report > Run > Uninvoiced Receipt report
3. The program runs for long time 

Tkprof shows the following expensive sql :

SELECT ROUND(DECODE(NVL(POL.ORDER_TYPE_LOOKUP_CODE,'QUANTITY'),'RATE',
NVL(RCT.AMOUNT,0),'FIXED PRICE',NVL(RCT.AMOUNT,0),
NVL(RCT.SOURCE_DOC_QUANTITY,0)),:b1) RCT_QTY,RCT.TRANSACTION_TYPE,
RCT.PARENT_TRANSACTION_ID
FROM
RCV_TRANSACTIONS RCT,PO_LINES_ALL POL

WHERE TRUNC(RCT.TRANSACTION_DATE) <= :b2 AND POL.PO_LINE_ID =
RCT.PO_LINE_ID AND RCT.TRANSACTION_TYPE IN (
'RECEIVE','MATCH','RETURN TO VENDOR','CORRECT' )CONNECT BY
RCT.PARENT_TRANSACTION_ID = PRIOR RCT.TRANSACTION_ID START WITH
RCT.TRANSACTION_ID = :b3

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms