Slow Performance In Document Search Screen When Searching For Invoices By Other Than Supplier

(Doc ID 847812.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Retail Invoice Matching - Version 12.1 and later
Information in this document applies to any platform.
Checked for relevance on 17-FEB-2012


You observe a performance issue on the Document Search screen while searching for invoices using criteria other than supplier. 

Steps to Reproduce
1. Login into ReIM. (Ensure that there are millions of records in IM_DOC_HEAD table)
2. On "Document Maintenance" tab,click on "Document Search".
3. In "Document Search" screen "Action" - "View".
4. Enter Order number or any other field other than supplier and click on "OK". It takes a very long time to display the results.




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