Error on RMS Order Worksheet: 'ORA-01400: cannot insert NULL into ORDLOC_WKSHT.ORDER_NO' When Removing All Prepacks from [ordmtxws] (Doc ID 2142495.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1 to 14.1.2 [Release 14.1]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Merchandising System (RMS), when attempting to remove all prepacks from the order worksheet [ordmtxws] and add a new one, the following error occurs:


Steps to Recreate:

  1. Create an order, selecting the prepack checkbox.
  2. Press Items button and enter the [ordmtxws] form.
  3. Add a prepack.
  4. Remove the pack using the Delete Item button (Note: the Delete All button will not generate the error).
  5. Add a new prepack (same configuration or not).
  6. 'Cannot insert NULL' error occurs.

Changes

 

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