If a custom attribute's Label matches Clarity's seed data's ID, during upgrade, translation is done based on the seed data, hence custom attribute's translation is lost after upgrade

Document ID : KB000056645
Last Modified Date : 14/02/2018
Show Technical Document Details

Steps to Reproduce:
1. Change the language to Japanese in Account Settings
2. Match Custom attribute's Label and Clarity's seed data's ID. ex) create attribute named “NAME” or “ID” against some portlet/Object/Lookup.
3. Change Label name for Japanese language.
4. Note the Column Labels and List Filter columns as expected
5. Note the Column Labels in Japanese locale and language
6. Upgrade Clarity from 13.1 to 13.2/13.3
Expected Results: The Japanese Column Lables are still present
Actual Result: Column Lables are restored to the out of the box values
This is documented as a defect CLRT-74030.
Workaround:
On a 12.1.1 system:
1. Run the following SQL on the 12.1.1 environment.
[Login Oracle with SQLPLUS]
 
set linesize 150
col id format 9999999999
col name format a90
col pk_id format 9999999999
col table_name format a30
set colsep ','
 
spool sql_result_ja_12.1.1.txt
 
select id, name, pk_id, table_name from cmn_captions_nls
where language_code = 'ja'
and (table_name = 'ODF_VIEW_ATTRIBUTES'
or table_name = 'CMN_GRID_COLS'
or table_name = 'CMN_BROWSE_PORTLET_ATTRIBUTES')
 
spool off
 
(Note) Backup existing cmn_captions_nls records for Japanese.

2. save sql_result_ja_12.1.1.txt file
 
3. Run the folllowing SQL on the 12.1.1 environment.
 
[Login Oracle with SQLPLUS]
 
spool sql_result_my_12.1.1.txt
 
update cmn_captions_nls set name=concat('my_',name)
where language_code = 'en'
and (table_name = 'ODF_VIEW_ATTRIBUTES'
or table_name = 'CMN_GRID_COLS'
or table_name = 'CMN_BROWSE_PORTLET_ATTRIBUTES')
 
select count(*) from cmn_captions_nls
where language_code = 'en'
and (table_name = 'ODF_VIEW_ATTRIBUTES'
or table_name = 'CMN_GRID_COLS'
or table_name = 'CMN_BROWSE_PORTLET_ATTRIBUTES')
and name like 'my_%'
 
spool off
 
(Note) In this step, in order to have unique name in comparison with Seed Data, add prefix to 'ODF_VIEW_ATTRIBUTES' , 'CMN_GRID_COLS' and 'CMN_BROWSE_PORTLET_ATTRIBUTES'.

4. save sql_result_my_12.1.1.txt file
5. Upgrade to 13.3
6. After upgrade to 13.3, find i18n.xml under config directory and verify if oracleSortName="JAPANESE_M".
<sortMapping languageCode="ja" oracleSortName="JAPANESE_M" oracleMultilingualSortName="JAPANESE_M"
mssqlCollation="Japanese_Unicode_CI_AS_KS"/>
 
7. Run the folllowing SQL on the 13.3.0 environment.
 
[Login Oracle with SQLPLUS]
 
spool sql_result_my_13.3.0.txt
 
update cmn_captions_nls set name=substr(name,4)
where language_code = 'en'
and (table_name = 'ODF_VIEW_ATTRIBUTES'
or table_name = 'CMN_GRID_COLS'
or table_name = 'CMN_BROWSE_PORTLET_ATTRIBUTES')
and name like 'my_%'
 
select count(*) from cmn_captions_nls
where language_code = 'en'
and (table_name = 'ODF_VIEW_ATTRIBUTES'
or table_name = 'CMN_GRID_COLS'
or table_name = 'CMN_BROWSE_PORTLET_ATTRIBUTES')
and name like 'my_%'
 
spool off
 
8. save sql_result_my_13.3.0.txt file
 
9. Run the folllowing SQL on the 13.3.0 environment.
 
[Login Oracle with SQLPLUS]
 
set linesize 150
col id format 9999999999
col name format a90
col pk_id format 9999999999
col table_name format a30
set colsep ','
 
spool sql_result_ja_13.3.0.txt
 
select id, name, pk_id, table_name from cmn_captions_nls
where language_code = 'ja'
and (table_name = 'ODF_VIEW_ATTRIBUTES'
or table_name = 'CMN_GRID_COLS'
or table_name = 'CMN_BROWSE_PORTLET_ATTRIBUTES')
 
spool off
 
10. save sql_result_ja_13.3.0.txt file
 
11. Please check sql_result_ja_12.1.1.txt, sql_result_my_12.1.1.txt, sql_result_my_13.3.0.txt and sql_result_ja_13.3.0.txt to verify this workaround.