My Oracle Support Banner

ORA-01400: cannot insert NULL returned by program unit BOL_SQL.FLUSH_SHIPSKU_INSERT When Receiving unShipped Transfers (Doc ID 2677792.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms



Receiving message failed in RMS-RIB with error-javax.ejb.EJBException: Exception while processing request:

"Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] Error ORA-01400: cannot insert NULL into ("XXX"."SHIPSKU"."SHIPMENT") returned by program unit BOL_SQL.FLUSH_SHIPSKU_INSERT."

Steps to reproduce:

  1. Receive a transfer which is not yet shipped.
  2. Note the above error occurs.
  3. Also TSFDETAIL.RECEIVED_QTY is updated.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.