My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

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


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.


  1. Login to web client with user whose Preference Language 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





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

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