Invalid Date When Importing Data Into Document Management Attribute Form (Doc ID 2925354.1)

Last updated on FEBRUARY 02, 2023

Applies to:

Symptoms

ACTUAL ISSUE
-----------------------

When importing a csv file into the Document Attribute Form for Document Management documents, the status file downloaded after the import shows the errors below and the data is not updated. Users are able to update the attribute form manually through the UI with the same data.

ERROR
-----------------------

Invalid [DATE_DE_NAME]: [DATE_VALUE]

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into Unifier
2. Navigate to desired Shell > Document Management > Documents
3. Click on Action, selects Export > Structure and Properties (CSV) and downloads the csv file
4. Open file in Excel
5. Add desired data, include a date value
6. Save csv file
7. Back in Unifier, highlight the row(s) of documents to update
8. Click Actions and select Import > Structure and Properties (CSV)
9. Browse to and select the csv file
10. Click Open
11. Receive pop up message: Import Completed. Do you want to download a file with detailed status?
12. Click yes and open the csv file in Excel
13. Each row shows Invalid [DATE_DE_NAME]: [DATE_VALUE].

Cause

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