My Oracle Support Banner

Case Management Upload Doc Error (Doc ID 2766790.1)

Last updated on MAY 13, 2022

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.


Issue is in 802 Environment.

Steps to reproduce the issue

1. Select Case ID in ECM
2. Click Resolution tab
3. Select Action as "No SG STR Filed - Close" , fill in comments section
3. Click Save and Attach button
4. provide logical filename
5. Choose file to be attached
6. Click attach file button

Errors in the log:

[UMMLOG] Feb 10,21 11:15:05 : [FORMSERVICE]Insert into DB operation called
[UMMLOG] Feb 10,21 11:15:05 : [RDBMSDAOHANDLER]Execute Update Query...INSERT INTO CM_ENTITY_DOCUMENT_MAP (n_entity_document_id,N_DOCUMENT_ID,v_document_absolute_name,V_DOCUMENT_NAME,N_ENTITY_ID) VALUES ('800128','60250','New Text Document.txt','test','1200155')
[UMMLOG] Feb 10,21 11:15:05 : [LOGGER]ORA-02291: integrity constraint (OFSAA_FCCM.IFK3_KDD_CASE_ACTN) violated - parent key not found

java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OFSAA_FCCM.IFK3_KDD_CASE_ACTN) violated - parent key not found


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.