My Oracle Support Banner

Primavera Cloud (OPC) XER Project File Fails to Import into P6 EPPM With an Error "Cannot insert NULL into "ADMUSER"."RSRCROLE"."ROLE_ID") (Doc ID 3055516.1)

Last updated on DECEMBER 09, 2024

Applies to:

Oracle Primavera Cloud Service - Version 24.4 and later
Primavera P6 Enterprise Project Portfolio Management - Version 22.12.1.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Primavera Cloud (OPC) XER Project File Fails to Import into P6 EPPM wit an error but Does Successfully Import into P6 PPM

 

ERROR
---------------
RMDB-1423-4, Message: PRM DBAccess Error: ORA-01400: cannot insert NULL into ("ADMUSER"."RSRCROLE"."ROLE_ID")

 

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

  1. From Primavera Cloud (OPC) export project schedule as XER.
  2. Import XER project schedule into P6 (EPPM) Professional.

 

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!


In this Document
Symptoms
Cause
Solution
References


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