Why Is RILMAINT Batch Failing With Error ORA-01403? (Doc ID 2032233.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.

Goal

The Retail Merchandising System (RMS) batch RILMAINT is failing with the following error:

 

Steps to Reproduce:

  1. RILMAINT starts and selects some records from REPL_ITEM_LOC_UPDATES.
  2. During batch execution, but before treatment of particular row with CHANGE_TYPE in (RIL, RILRC) users deactivate replenishment for this item-location- and rows from REPL_ITEM_LOC and REPL_ITEM_LOC_UPDATES with change_type != RILD are deleted and new rows with change_type = RILD is are inserted in REPL_ITEM_LOC_UPDATES.
  3. When RILMAINT tries to treat item-location-bunch for which replenishment was deactivated, it ends with error 'ORA-01403' shown above.


Why is this error occurring? How can we prevent this?

Solution

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