My Oracle Support Banner

Bug 21122155: Label Request Missing Custom Sql Fields When Multiple Label Requests Were Raised (Doc ID 2043591.1)

Last updated on MARCH 08, 2017

Applies to:

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


On : 12.1.3 version, LPN Management

Label request missing custom sql fields when multiple label requests were raised

Problem Description
Within LPN Summary label type, we defined "LPN Summary.lwl" label format with mostly the seeded fields/variables. We do have a few custom fields written in custom sql included in "LPN Summary.lwl".

We linked LPN Summary label type to receipt business flow.

When we perform a PO receipt using a handheld, when we receive in multiple LPNs which would in turn trigger multiple label requests, only the first label request contain the custom fields/variables in the XML output file. The XML file for the subsequent label requests only contain the seeded variables, no custom variables.

Expect custom fields to also be printed on additional labels generated.

The issue has the following business impact:
1) The issue is in a test environment of our, but our production go live is set for June 1st.
2) Production go live is our next milestone.
3) See above answers.
4) If we had to delay the go live, the estimated cost is 1 million dollars per month of delay.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.