Out Of Memory Crash During Item Search Using Wildcard In Back Office (Doc ID 2258336.1)

Last updated on APRIL 28, 2017

Applies to:

Oracle Retail Back Office - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Back Office (ORBO) 14.1.2, out of memory crash is happening during item search using wildcard.

Steps to reproduce the issue:

  1. Prepare using DIMP an ORBO database with over 100k rows in the CO_MRHRC_GP, 1 row in the CO_MRHRC_FNC and make association between them through the ST_ASCTN_MRHRC table;
  2. Connect the database to the ORBO application;
  3. Login to the ORBO;
  4. Go to the item tab;
  5. Look up for items using wild card search;
  6. Notice that the application crashes.

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