My Oracle Support Banner

ECM SECURITY BATCH FAILING IN PROD (Doc ID 3079492.1)

Last updated on APRIL 06, 2025

Applies to:

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

Symptoms

ECM Security batch is failing in PROD. 

When we ran the batch - for user U27801 it failed with error.

Error Msg :-> ORA-02291: integrity constraint (PFCCMATOMIC.FK_1026_2) violated - parent key not found
ORA-06512: at "PFCCMATOMIC.P_USER_SECURITY_ATTR_MAP", line 482
ORA-06512: at "PFCCMATOMIC.P_ECM_USER_POPULATION", line 378
ORA-06512: at "PFCCMATOMIC.P_ECM_USER_POPULATION", line 195
ORA-06512: at "PFCCMATOMIC.P_USER_SECURITY_ATTR_MAP", line 37
ORA-06512: at "PFCCMATOMIC.FN_USER_SECURITY_ATTR_MAP", line 6
ORA-06512: at line 1

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
Cause
Solution
References


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