Unable to Delete an Enterprise Capture Document Profile in a Copied Workspace and Error " ORA-02292: Integrity constraint is violated-child record is found" (Doc ID 2224985.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

After making a copy of an Enterprise Capture workspace, the below error occurs when deleting the Document Profile:

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: Integrity constraint (OCAP1_CAPTURE.FK_CCMMTPRFLDCCDCTYPD) is violated-child record is found
Error Code: 2292
Call: DELETE FROM ECDOCUMENTTYPES WHERE (ECDOCTYPEID = ?)
bind => [1 parameter bound]
Query: DeleteObjectQuery(oracle.odc.entity.DocumentEntity[id=a994aff2-6543-46d3-874c-1c31271d7202])
Error ORA-02292: Integrity constraint (OCAP1_CAPTURE.FK_CCMMTPRFLDCCDCTYPD) is violated-child record is found

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