[SOLVED] Chinese Translation - Calendar Issues

[chrisplough]

FYI,There is an issue with OTM v5.5 with the Chinese translation and calendars (Oracle Bug 6124690). When displaying in Chinese, the Calendar image is showing the month drop-down as comma separated values, due to a bug. This is slated to be resolved in OTM v6.0, but there is a quick workaround for current versions.

Proposed Solution:

1) Ensure that you have taken a backup of the TRANSLATION_D table before applying the recommended solution.

2) Run the following scripts in a TEST environment first:

update TRANSLATION_D set text = '一月,二月,三月,四月,五月,六月,七月,八月,九月,十月,十一月,十二月' WHERE TRANSLATION_GID LIKE 'calendar.month_names' and lang = 'zh';
update TRANSLATION_D set text = '「星期日,星期一,星期二,星期三,星期四,星期五,星期六」' WHERE TRANSLATION_GID LIKE 'calendar.dow_abbrevs' and lang = 'zh' and country = 'TW';

3) Once the scripts complete, confirm that the data is corrected. You can use the following SQL to confirm:

SELECT * FROM TRANSLATION_D WHERE TRANSLATION_GID LIKE 'calendar.dow_abbrevs' and lang = 'zh';
SELECT * FROM TRANSLATION_D WHERE TRANSLATION_GID LIKE 'calendar.month_names' and lang = 'zh';

The result of both these queries should show the values in the TEXT column separated by a comma.

4) If you are satisfied with the results, issue a commit.

5) Re-start the web and application servers for this change to take effect.

6) Confirm that the data is corrected when viewed in the OTM UI. You can use the following steps:

a) Go to Order Management - Order Manager - Order Release - New
b) Click on the calendar symbol next to Early Pick Up Date field.
c) The months name should display one by one in the month drop-down

7) Migrate the solution as appropriate to other environments.

Hope this helps!

--Chris