Basel IV upgrade from 8.1.1.1.1 to 8.1.2.0.0 Completed with Error:ORA-02292: integrity constraint (OFSAACONF.AAI_WF_PROCESS_EXECUTION_FK) violated - child record found (Doc ID 2888965.1)

Last updated on JANUARY 17, 2024

Applies to:

Symptoms

Basel application upgraded from 8.1.1.1.1 to 8.1.2.0.0 Completed with below error.

OFS_BASEL_BASIC_installation.err:

[INFO ] Executing file :/ofsaa/ofsaa/installerScripts/OFS_BASEL_BASIC/scripts/config/insert/PMFBNK021_0.sql
[15-07-22 11:36:29,320 AST AM] [ERROR] Query:delete from aai_wf_process_b where v_process_id = 'PMFBNK021'...
Error:ORA-02292: integrity constraint (OFSAACONF.AAI_WF_PROCESS_EXECUTION_FK) violated - child record found

[ERROR] Query:insert into aai_wf_process_b(v_process_id,v_process_status,v_access_level,v_default_activity_id,d_created_date,v_created_by,v_app_package_id,v_display_height,v_display_width,v_tag,n_version,v_process_code,V_IS_RUN,V_IS_SIMULATION_RUN,V_INFODOM,V_FOLDER_NAME,D_VALID_FROM,D_VALID_TILL,D_MODIFIED_DATE,V_MODIFIED_BY,V_RUN_DISPLAY_PROP,V_SRC_LOCALE,V_IS_FACTORY,V_RUNSK_REQUIRED,V_IS_SPARK_DB,V_IS_INLINE,V_SELECTED_TOPIC,V_PARENT_PROCESS,V_ROOT_PROCESS) values('PMFBNK021','START','PUBLIC','Job_45664ea19f1d4569b7b21e45e3557013',sysdate,'SYSADMN','200','0','0','BUS',0,'PMFBNK021','N','N','OFSAAEPM','0f5bbf4a-6ebd-4ad0-82cb-2b2f314c38b8','',sysdate,sysdate,'SYSADMN','','','','SUBRUNPROCESS','N','','','','PMFBNK021')...
Error:ORA-00001: unique constraint (OFSAACONF.AAI_WF_PROCESS_PK) violated

[INFO ] # statements executed: 173 , time consumed in milliseconds: 825
[INFO ] Executing file :/ofsaa/ofsaa/installerScripts/OFS_BASEL_BASIC/scripts/config/insert/PMFSEC001_0.sql
[ERROR] Query:delete from aai_wf_process_b where v_process_id = 'PMFSEC001'...
Error:ORA-02292: integrity constraint (OFSAACONF.AAI_WF_PROCESS_EXECUTION_FK) violated - child record found

Cause

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