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 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Information in this document applies to any platform.


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

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

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.

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




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