Item Description Generation On Item Form (INVIDITM) Using Catalog In Non-English Like German, French, Russian Is Not Updating Base Table (MTL_SYSTEM_ITEMS_B) (Doc ID 2812011.1)

Last updated on MAY 01, 2023

Applies to:

Goal

Why does the base table description (MTL_SYSTEM_ITEMS_B) get out of synchronization with the translated values (MTL_SYSTEM_ITEMS_TL)?

This occurs only when the user language selected is something other than the base English / US language. For example, the user may choose French, Spanish, Russian, etc.  This issue occurs only when the item is created in another language that is NOT English.

Users see no issues in the forms or reports. Custom reports however use the base table description so are incorrect.

No issues updating the description via the Catalog in Inventory > Items > Master Items then choosing Tools > Catalog > Update Description.

Even updating the same in Spanish no issues on the form. The form looks fine for the user.

STEPS A: Baseline Working in English:
Here is an Example Test to walk though the issue. This first set of Steps show a baseline working case in English.

1. In English / US base language... Create an item
Navigate to inventory > items > master items
In the master org V1, create item: TEST123 with description Test123
Also assign the same item to another child org M1.

2. Navigate to inventory > items > master items or organization items
Query the item.
See no issues.

3. Check the results in SQL:
select inventory_item_id, segment1, description, organization_id from mtl_system_items_b where segment1 like 'TEST123';
DESCRIPTION Test123 << For all rows.

select * from mtl_system_items_tl where INVENTORY_ITEM_ID IN (select inventory_item_id from mtl_system_items_b where segment1 like 'TEST123');
DESCRIPTION Test123 << For all rows.

* So far, everything is working fine and the _B base table description matches the _TL translation table.

4. Update the Catalog on the item form using Tools >  Catalog.
As an example, select catalog "A&D Components" and choose the "Update Description" Button.
The description changes to "A&D Components."

5. Check the results in SQL:
select inventory_item_id, segment1, description, organization_id from mtl_system_items_b where segment1 like 'TEST123';
DESCRIPTION A&D Components. << For all rows.

select * from mtl_system_items_tl where INVENTORY_ITEM_ID IN (select inventory_item_id from mtl_system_items_b where segment1 like 'TEST123');
DESCRIPTION A&D Components. << For all rows.

* So far, everything is working fine and the _B base table description matches the _TL translation table.

STEPS B: Not Working in Spanish:

1. In Spanish or any other language that is NOT English... Create an item
Navigate to inventory > items > master items
In the master org V1, create item: TEST123B with description Test123
Also assign the same item to another child org M1.

2. Navigate to inventory > items > master items or organization items
Query the item.
See no issues.

3. Check the results in SQL:
select inventory_item_id, segment1, description, organization_id from mtl_system_items_b where segment1 like 'TEST123B';
DESCRIPTION Test123 << For all rows.

select * from mtl_system_items_tl where INVENTORY_ITEM_ID IN (select inventory_item_id from mtl_system_items_b where segment1 like 'TEST123B');
DESCRIPTION Test123 << For all rows.

* So far, everything is working fine and the _B base table description matches the _TL translation table.

4. Update the Catalog on the item form using Tools >  Catalog.
As an example, select catalog "A&D Components" and choose the "Update Description" Button.
The description changes to "A&D Components."

5. Check the results in SQL:
select inventory_item_id, segment1, description, organization_id from mtl_system_items_b where segment1 like 'TEST123B';
DESCRIPTION Test123 or A&D Components. << The items may all remain Test123 or some may show Test123 and others as A&D Components. It is not consistent.

select * from mtl_system_items_tl where INVENTORY_ITEM_ID IN (select inventory_item_id from mtl_system_items_b where segment1 like 'TEST123B');
DESCRIPTION A&D Components. << For all rows.

* This shows the issue. The _B base table description does not change or does not change for all organizations. The description however is correct and matches in the _TL translation table for all languages.

Solution

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