11i Uninvoiced Receipt Report Performance Issue
Last updated on DECEMBER 23, 2015
Applies to:Oracle Purchasing - Version 11.5.10 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
On : 11.5.10 version, Accounting related
Uninvoiced Receipt report runs has the performance issue and runs for long time.
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 :
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
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