XER Import Fails With: ORA-12899: Value Too Large For Column "ADMUSER"."UDFTYPE"
(Doc ID 2320607.1)
Last updated on FEBRUARY 01, 2021
Applies to:Primavera P6 Professional Project Management - Version 7.0 SP1 and later
Information in this document applies to any platform.
Attempting to import one XER file in P6 Professional fails with the following error:
Event Code: PRMDB-0114-4
Description: PRM DBAccess Error: Database Server Error: ORA-12899: Value too large for column "ADMUSER"."UDFTYPE"."UDF_TYPE_LABEL" (actual: 43, maximum: 40)
The issue can be reproduced at will with the following steps:
1. Login using P6 Professional.
2. File - Import - Primavera XER.
The issue has the following business impact:
Due to this issue, users cannot import the XER file.
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