WMS Label Request And Custom Label Print: No Link Between Label Request And PO Receipt (Doc ID 1499408.1)

Last updated on MAY 18, 2016

Applies to:

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

Goal

Problem when generating Receipts Labels using Material label (custom) type with the business flow Receipt.

You need to print information about a PO receipt. It is generating Receipts Labels using Material label type with the Receipt business flow. It works with standard label (for instance: Receipt Number).
Problem is about extra information in the header receipt like COMMENTS, BILL_OF_LADING, NUM_OF_CONTAINERS. You'd like to find values in the label content.
In this way, you would like to use custom label. However, it has been noticed that the table wms_label_requests and wms_label_requests_hist do not have any field that can be reference to a PO Receipt.

Problem is about printers & devices in WMS setup. When a PO Receipt is entered, XML is automatically generating in Label Requests History (Path: Inventory / Transactions / View Label Requests) with this Setup:
Path: Setup / Warehouse Configuration / Printers & Devices / Define Label Format
=> Label Type = Material
Path: Setup / Warehouse Configuration / Printers & Devices / Assign label Types to Business Flows
=> "Material" Label Type is assigned to "Receipt" business flow
Path: Setup / Warehouse Configuration / Printers & Devices / Assign printers to Document
=> Printer is assigned to "Material" document"

Contents XML: Standard labels are printed (especially "Receipt number" field)=> OK

You want that us to print more information. So, it try to use setup to customize labels print for the "material" label type.

Path: Setup / Warehouse Configuration / Printers & Devices / Define Custom SQL Fields
=> It works correctly when there is a link between wms_label_requests and the table with extra information.

For instance, you enter this request in custom field and it's OK:

Your problem is to find a reference to link RCV_HEADERS_INTERFACE with WMS_LABEL_REQUESTS in order to print COMMENTS, BILL_OF_LADING, NUM_OF_CONTAINERS information in XML contents (when a PO receipt is entered) using the Custom SQL Fields Setup.

Information like COMMENTS, BILL_OF_LADING, NUM_OF_CONTAINERS are available into RCV_HEADERS_INTERFACE table.

You would like to have a link between the label request and the PO receipt to find information or a workaround.

Solution

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