My Oracle Support Banner

Error: ??? Integrity Constraint Violation Deleting P6 User. ORA-02292: Integrity Constraint (ADMUSER.FK_$TABLENAME_USERS) Violated - Child Record Found (Doc ID 2054290.1)

Last updated on MARCH 07, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3.2.0 and later
Information in this document applies to any platform.

Symptoms

When saving changes after deleting user accounts the following error occurs.

ERROR
-----------------------
????

ERROR IN LOG
-----------------------
ORA-2292: integrity constraint (ADMUSER.FK_$TABLENAME_USERS) violated - child record found.

The following tables are effected:
DISCUSSION_READ
RPT
RSRCANVIEW
USERWKSP
PROJECT


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to delete users
2. Attempt to save.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot save changes for deleted users.

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.