My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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