PIM/Product Hub Change Order Implements Changes On Translatable UDA For All Languages And Cannot Turn Back To Current Value

(Doc ID 1680588.1)

Last updated on FEBRUARY 01, 2018

Applies to:

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

Symptoms

Actual Behavior
In English user session, changes to UDAs get translated to other languages, this is not desired.

Expected Behavior
Make changes to the translatable attribute only English Session with change order

Steps to Reproduce

  1. Create an Item Catalog Category (ICC) with an attribute group that contains a translatable attribute.
  2. Create an item using this ICC
  3. In English session, set translatable attribute to "ENG_1"
  4. In Japanese session, set translatable attribute to "JPN_1"
  5. Confirm EGO_MTL_SY_ITEMS_EXT_TL
    SQL>
    SELECT inventory_item_id,source_lang,language,tl_ext_attr1
    FROM ego_mtl_sy_items_ext_tl
    WHERE inventory_item_id = <item_id>
    and attr_group_id = <attr_grp_id>
    ORDER BY language;
EGO_MTL_SY_ITEMS_EXT_TL
SOURCE_LANG LANGUAGE TL_EXT_ATTR1
JA JA JPN_1
US US ENG_1

In this situation, we would like to make changes to the translatable attribute only English Session with change order.Translatable attribute(English Session)  : "ENG_1" --> "ENG_2"
Translatable attribute(Japanese Session) : "JPN_1" --> "JPN_1" (remain the same)

Create a change order for this item and make changes to the translatable attribute in English Session. (English Session)
  Attribute                    | Current | New
  --------------------------------------------
  Translatable attribute | ENG_1   | ENG_2  

Confirm EGO_ITEMS_ATTRS_CHANGES_TL
SQL>
SELECT
inventory_item_id, change_id, change_line_id, acd_type,
source_lang, language, tl_ext_attr1
FROM ego_items_attrs_changes_tl
WHERE inventory_item_id = <item_id>
ORDER BY language;

 

EGO_ITEMS_ATTRS_CHANGES_TL
SOURCE_LANG LANGUAGE TL_EXT_ATTR1
US JA ENG_2
US US ENG_2

In Japanese session, open a change order and confirm the translatable attribute (Japanese Session)
  Attribute                   | Current | New
  --------------------------------------------
  Translatable attribute | JPN_1   | ENG_2  

Set translatable attribute to "JPN_1" in change order.
==>Unable to turn back translatable attribute to "JPN_1"

Changes

 

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