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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
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.
