ORDMTXWS Screen Displays Error Message When Creating a Prepack Order: 'The required input parameter loc_type OR hier_level of program NEW_ITEM_LOC_SQL.VALIDATE is null' (Doc ID 2101569.1)

Last updated on FEBRUARY 02, 2016

Applies to:

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


Order Distribution Worksheet [ordmtxws] screen displays the following error message if no receiving location is added for a prepack order:

 Steps to Reproduce:

  1. Create a new order using PO Header Maintenance [ordhead] screen.
  2. Leave the location and location type blank and check the prepack flag for the order.
  3. On ordmtxws screen, create a prepack using the apply template button.
  4. Press ok on ordmtxws screen and note that the error message above is displayed.


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