My Oracle Support Banner

Error "Invalid Date Value: XX-XX-XX XX:XX:XX. DATE FORMAT: MM/DD/YYYY." Received While Importing .CSV File With the Date Field Auto-Populated from Another Field (Doc ID 2961374.1)

Last updated on JULY 14, 2023

Applies to:

Primavera Unifier Cloud Service - Version 23.6 and later
Information in this document applies to any platform.

Symptoms

Importing data using a CSV file to create a Business process (BP) record that has a Date field which is Auto-Populated from the another field (i.e. data for the Date field is not in the CSV file) throws the error below -

         "Invalid Date. Value: xx-xx-xxxx xx:xx:xx. Date Format: MM/dd/yyyy."


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

  1. Log in to Unifier.
  2. Navigate to e.g. Project_XYZ > BP_DailyReports > Actions > Import > Data From CSV File.
  3. Select the .CSV file with data to import (note: that the date field within the .CSV file does not have any value).
  4. Observe that the import is not successful and the above error msg is received within the BP_DailyReports_error.csv file.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.