My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.