Batch Rplbld Aborts in Process for Crossdock Replenishment: 'ORA-01400: cannot insert NULL into ()~INSERT in package insert_alloc_detail'

(Doc ID 2152484.1)

Last updated on MAY 01, 2017

Applies to:

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


When attempting to run the RPLBLD batch, the following error occurs.

Steps to Reproduce:

  1. Create an item
  2. Create a replenishment in RMS UI.
  3. Set the order control to 'S'emi automatic.
  4. Create another replenishment for the same item, but in a different store location.
  5. Set the order control to 'A'utomatic.
  6. Run the replenishment batch.
  7. Rplbld aborts with the error above.



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