Sql Query for Custom Label Fields in Wms Is Not Returning Any Data in the Xml Output (Doc ID 2037068.1)

Last updated on JUNE 07, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Users has SQL Query for custom label fields in LPN Contents label format and attached it to the Receipt business flow.

When PO receipt is performed the xml output of the LPN contents label is not returning any data (its NULL) for the Custom label field

For Eg , SQL Query for custom label fields in LPN Contents label format is

Vendor #
========
Select aps.segment1 from wms_label_requests wlr, ap_suppliers aps where wlr.supplier_id = aps.vendor_id UNION SELECT ' ' FROM wms_label_requests wlr WHERE not exists (select aps.segment1 from wms_label_requests wlr, ap_suppliers aps where wlr.supplier_id = aps.vendor_id) AND ROWNUM=1

XML Output of the Label Request :

EXPECTED BEHAVIOR
-----------------------
SQL Query for custom label fields to return data in the xml output.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup Label format with Customer SQL fields for LPN Contents label.
2. Attach the label to Business flow = Receipt.
3. Perform a Receipt into an LPN
4. Check the label output generated.

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