Import With XLSX File to Update Date Attribute Results in java.util.date Error or Unexpected Date With Japanese User (Doc ID 2110408.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

Actual Issue
When logging in Japanese language user, export XLS file for a certain part. Save the XLS file to XLSX file through Excel application.
Modify the XLSX file to change the page two date attribute value using Import. During import validation, below error occurs.

Could not convert value '1/20/16' into the appropriate datatype (java.util.Date)

Also, there are cases when even the date on XLSX file is set to 2016/2/4, after import, the date is set to '2002/04/16 00.00.00 JST' which is not correct.  

What is Found

  1. This issue occurs only when the source file is XLSX file.
  2. This issue does not occur when user language is set to English.
  3. The import user is set to Preferred Date Format:yyyy/MM/dd. When set to Preferred Date Format:MM/dd/yyyy, issue does not occur.

Step

  1. Login to web client in admin user. Language is set to Japanese.

    Preferred Date Format:yyyy/MM/dd

  2. Export part object to XLS file
  3. Open the xls file in excel application.
  4. Modify the excel sheet to the following

    Number    PAGE_TWO.DATE01
    -----------------------------------
    TEST34    2016/1/20
    TEST35    2016/2/4

  5. Save the excel to XLSX file through excel application.
  6. In Web client, set the import source file to XLSX file
  7. On the redline option: Set a new change
  8. Map the attribute for Number and page two date 01 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