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 laterInformation 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 |