My Oracle Support Banner

UDF Data Is Not Included When Exporting a Project to Microsoft Project XML Format (Doc ID 2300661.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version to [Release 8.4 to 15.1]
Primavera P6 Enterprise Project Portfolio Management - Version to [Release 15.2]
Information in this document applies to any platform.


When exporting projects to Microsoft Project 2010 eXtensible Markup Language (XML) format, User Defined Fields (UDFs) are not exported and the following error occurs in the P6WebAccess.html log file:

com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT udftype.udf_type_name UDFTypeName,udftype.udf_type_label UDFTypeLabel FROM udftype WHERE (udftype.udf_type_name=XXX)}
Caused by: Invalid column name 'XXX'

This issue can be reproduced at will with the following steps:
1. Create a new project.
2. Create a text UDF.
3. Add a new activity.
4. Enter the UDF field data.
5. Export the project to Microsoft Project XML format.
6. Import file into Microsoft Project
7. Note that UDF data is not exported.

Due to this issue, users cannot export UDF data in Microsoft Project 2010 XML format.


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.