Import Errors Out When Updating Lifecycle Phase via XLSX File in Japanese

(Doc ID 2112851.1)

Last updated on FEBRUARY 19, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 to 9.3.5.0 [Release 9.3]
Information in this document applies to any platform.

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

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