Error: "PRM DBAccess Error:ORA-02292:INTEGRITY CONSTRAINT (ADMUSER.FK_TRSRCFIN_TASKRSRC) VIOLATED " When Deleting a Project With Financial Period Data

(Doc ID 2322917.1)

Last updated on NOVEMBER 09, 2017

Applies to:

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

Symptoms

When attempting to delete a specific project,
the following error occurs.

ERROR
-----------------------
PRMDB-0376-5
IPRM DBAccess Error: ORA-02292: integrity constraint (ADMUSERPC.FK_TRSRCFIN_TASKRSRC) violated - child record

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to P6 Pro for EPPM.
2. Navigate to projects list view.
3. Try to delete the specific project.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot delete the specific project.

Changes

 

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