My Oracle Support Banner

Troubleshooting "The import file is not formatted correctly..." or "...Could not commit transaction..." Errors When Attempting to Use the Import Functionality in Contract Management (Doc ID 898798.1)

Last updated on APRIL 21, 2021

Applies to:

Primavera Contract Management - Version 11.0 to 14.2 [Release 11.0 to 14.2]
All Platforms
Contract Management data export and data import process is only supported in specific modules. The intent of these features is to move similar data from project to project, where applicable. This requires the data be manually entered into the application interface once.

The export \ import process is not designed as a batch data entry method without using the application user interface.
Manipulating the exported data prior to import may result in formatting issues.

Purpose

 The purpose of this document is to assist resolving the "The import file is not formatted correctly..." or "...Could not commit transaction..." errors when attempting to import into Contract Management

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Symptoms
 Cause 1 - Data in a column exceeds the database column width
 Cause 2 - Invalid date format
 Cause 3 - Submittal Export Report Contains Incorrect Syntax (Contract Management 14.x)
 Cause 4 - Document was saved using Office 2010
 Cause 5 - Data retaining formatting information
 Cause 6 - Mismatch between the column names
References

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