My Oracle Support Banner

OFSDM 806 Upgrade Errors (Doc ID 2625569.1)

Last updated on MAY 24, 2023

Applies to:

Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

User is upgrading Data Management to 806 in an integrated environment having BASEL and there are below scripts errors in the log :

Errors due to missing SEGMENT code in the queries :

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONFIG"."CSSMS_SEGMENT_MAST"."V_SEGMENT_CODE" )

Below Scripts were also fail with ORA-01400

config/insert/dgr_Cssms_usrgrp_dsn_unauth_pack.sql
/scripts/config/insert/dgr_Cssms_usr_group_dsn_map_pack.sql
/scripts/config/insert/dgs_cm_Cssms_usr_group_dsn_map_pack.sql
/scripts/config/insert/dgs_cm_Cssms_usrgrp_dsn_unauth_pack.sql
/scripts/config/insert/adj_Cssms_usrgrp_dsn_unauth_pack.sql
/scripts/config/insert/adj_Cssms_usr_group_dsn_map_pack.sql
/scripts/config/insert/dgr_adj_Cssms_pack.sql
/scripts/atomic/insert/DGS_WFM_LIST.sql
/scripts/atomic/insert/DGS_WFM_RULE_DETAILS.sql

Errors due to missing column in tables on which the queries were running
- Below have the issue:
/scripts/atomic/insert/DGS_WFM_MASTER.sql - N_OR_STATUS_CD column missing in DB
/scripts/atomic/insert/DGS_WFM_STAGE_DETAILS.sql - IS_COMMITTEE_STAGE column missing in DB
/scripts/atomic/insert/DGS_WFM_NOTIFICATION_DETAILS.sql - V_NOTIF_COMMENTS column missing

 scripts/atomic/insert/DGS_WFM_STG_ROUTE_RULE_MAP.sql -
    - Gives ORA-02291: integrity constraint (ATOMIC.FK_WFM_STG_ROUTE_RULE_MAP_1) violated - parent key not found
scripts/atomic/insert/dgs_WFM_NOTIF_ROLES.sql
    - Gives ORA-02291: integrity constraint (ATOMIC.FK_WFM_NOTIF_ROLES_1) violated - parent key not found
scripts/atomic/insert/con_Workflow_insert.sql
    - Gives ORA-02291: integrity constraint (ATOMIC.FK_WFM_ENTITY_STAGE_DTL_2) violated - parent key not found
scripts/atomic/insert/con_CDE_workflow_Inserts.sql
    - ORA-02291: integrity constraint (ATOMIC.FK_WFM_ENTITY_STAGE_DTL_2) violated - parent key not found
    - ORA-06512: at line 13

 

Changes

DM 8.0.6.0.0 was installed

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


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