Applies To:Oracle Inventory management-version:11.5.9 to 11.5.10.cu2-release:11.5 to 11.5
GOALWhat's the supported approach for using the Import Item concurrent Program (Incoin) to create and update items for MU Ltiple languages?SolutionPer INV techref 11.5.8 ETRM
Quote Section Mtl_system_items_b:
See DESCRIPTION column in the base table ...
"Items now support multilingual description. MLS is implemented with a
pair of Tables:mtl_system_items_b and MTL_SYSTEM_ITEMS_TL. Translations
table (MTL_SYSTEM_ITEMS_TL) holds item Description and Long Description
In multiple languages. DESCRIPTION column in the base table
(mtl_system_items_b) is-backward compatibility and is maintained
the installation base language only. "
Item Open Interface (IOI) is implemented so, there is no multilingual
Interface Table (_TL) counterpart to Mtl_system_items_interface, unlike
transaction tables where there is a pair of base/translations tables:
Mtl_system_items_{b,tl}.
.
Description and long_description text cannot be imported with IOI in multiple
language simultaneously. Item Description is imported on only one language
(=language of the session) per single Interface run, populating the
mtl_system_items_tl table with the SOURCE LANGUAGE of the import session.
Then the Description can is updated for any particular language by running an
Import in UPDATE mode at that language session.
When the description are controlled at the Master level, the description value would
Propagate to the child Organization. This can is tested by making an update through the
Application to the Master, and then confirm, it propagated to the child Org. any
attribute that can is updated via the form in the application would behave the same to through
also.
REFERENCES note:124283.1-Multilingual support in Oracle applications Release 11i
Incoin Importing multilingual Items (Doc ID 278126.1)
