In Label Printing For Multi Language, Item Description Is Displayed From MTL_SYSTEM_ITEMS_B Table (Doc ID 1900054.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Item Description from mtl_system_items_b instead of column from mtl_system_items_vl View
In Multi Languages environment the form Find Label Request uses description for an item as description from Table mtl_system_items_b instead of description from mtl_system_items_tl Table

According to the Note 356849.1

Whenever the Item description is used it has to be taken from the MTL_SYSTEM_ITEMS_TL Table not from the MTL_SYSTEM_ITEMS_B Table
The same issue is with label history and xml in label_content column in WMS_LABEL_REQUESTS_HIST Table.

EXPECTED BEHAVIOR
-----------------------
Expect Item Description to be taken from MTL_SYSTEM_ITEMS_TL Table

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility Warehouse Manager -> Inquiry -> View Label Requests -> Label Request History -> Find Label Requests -> Tab Label Info
2. Choose Organization, choose Item from LOV, field description from mtl_system_items_b

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