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 FEBRUARY 21, 2019

Applies to:

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.

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 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

Changes

Cause

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