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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms