Import Errors Out When Updating Lifecycle Phase via XLSX File in Japanese (Doc ID 2112851.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Symptoms

Actual Behavior
Import to update Lifecycle Phase ends in error when using XLSX file as source file.

What is found

1. User language is Japanese. Issue does not occur when language is English.
2. Issue occur on XLSX file only. Issue does not occur on XLS file 

Error
Line 2[ 部品 - 番号: P00026]: '部品.タイトル・ブロック.ライフサイクル・フェーズ'のエニュメレーション検証を実行中に、次のメッセージを受け取りました。エニュメレーション違反: 値'廃止ハイシ'が有効な値のリスト(パイロット, プレリミナリ, プロトタイプ, 製造, 停止, 廃止)内で見つかりません。

Step

1. Apply patch:21175511(HF 9.3.3.0.258)
2. Login to web client in admin user. Language is set to Japanese.
3. Export a specific part :P00026 to xls file
4. Open the xls file in excel application.
5. Modify the excel sheet to the following
   
   Before:
   

   番号	ライフサイクル・フェーズ
   P00026	プレリミナリ

   
   
   After:
   

   番号	ライフサイクル・フェーズ
   P00026	廃止

   
   
   
6. Save the excel file to xlsx file.
7. In Web client, set the import source file to xlsx file
8. On the redline option: Set a new change
9. Map the attribute for Number and LifeCycle Phase and perform import

Cause

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