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.

Symptoms

On : 12.1.3 version, LPN Management

ACTUAL BEHAVIOR
---------------
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.

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


BUSINESS IMPACT
-----------------------
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.

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