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 SEPTEMBER 28, 2022
Applies to:
Oracle WebCenter Enterprise Capture - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g]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
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
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 |
| Changes |
| Cause |
| Solution |
| References |