WMS Custom Label Field Prevents Label From Printing If Data Value Is Null Or Returns >1 Row (Doc ID 1175333.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When adding a custom label field to a label, the label will not generate if the data returned is null or returns > 1 row.
For example on a Material label when adding the customer ship-to address fields, if address line 2 is blank (null) on a given address, a warning is returned in label history and the label XML file is not generated.
The Error message returned is

 

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