Why Is RILMAINT Batch Failing With Error ORA-01403?
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.
The Retail Merchandising System (RMS) batch RILMAINT is failing with the following error:
Steps to Reproduce:
- RILMAINT starts and selects some records from REPL_ITEM_LOC_UPDATES.
- 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.
- 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?
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