Unable To Include Custom Label Fields On Material Label During Purchase Order Receipt For Non-WMS Organization As There Are No Receiving Fields In WMS_LABEL_REQUESTS
(Doc ID 2910092.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Warehouse Management - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
Users have to include a Receiving transaction descriptive flexfield on the Material label during Purchase order receipt. But, there is no option to add additional Receiving header / Receiving transaction DFF information on Labels as the wms_label_requests table does not include any Receiving columns. It does show Outbound (Shipping) related columns like sales_order_header_id, sales_order_line_id, delivery_id, Delivery_detail_id, etc. License Plate Number is one of the fields in this table, However, as Warehouse management is not enabled in this organizations , License Plate Numbers (LPNs) are not used.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup > Warehouse Configuration > Printer & Devices > Define Custom SQL Fields > << choose Material >>
2. Cannot use SQL as wms_label_requests table does not have any receiving related fields to join to Receiving tables. (rcv_transactions / rcv_shipment_header / rcv_shipment_lines)
3. For example, if we need attribute5 of rcv_transactions table included in the Material Label, There is no way to achieve this.
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |