My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2023

Applies to:

Primavera Unifier Cloud Service - Version N/A and later
Primavera Unifier - Version 9.7 and later
Information in this document applies to any platform.



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.



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


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.