Performance Issue with ReIM 13.2.x Automatch Batch (Doc ID 1914318.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Retail Invoice Matching - Version 13.2.4 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.
Checked for relevance on 11-Oct-2016

Symptoms

In Oracle Retail Invoice Matching (ReIM) 13.2.x, it is observed that the Automatch batch process takes an extremely long time to execute.  The main time consumption is happening in the V_IM_ORDLOC_STORES_PHYS_WH table.  The top query is doing a lot of logical reads, and the performance hit is being taken as sorting is happening inside this view.


Sample Steps to Reproduce:

  1. Take count of RMTCH Invoices at the begining of the batch.  (In sample test case, we began with 26402 invoices; number was reduced to 26055 after 3 hours of processing.)
  2. Run Automatch batch.
  3. Observe time it takes to process data.

Changes

 

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