OFSDM 806 Upgrade Errors
(Doc ID 2625569.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and later
Information in this document applies to any platform.
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
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
- Gives ORA-02291: integrity constraint (ATOMIC.FK_WFM_STG_ROUTE_RULE_MAP_1) violated - parent key not found
- Gives ORA-02291: integrity constraint (ATOMIC.FK_WFM_NOTIF_ROLES_1) violated - parent key not found
- Gives ORA-02291: integrity constraint (ATOMIC.FK_WFM_ENTITY_STAGE_DTL_2) violated - parent key not found
- ORA-02291: integrity constraint (ATOMIC.FK_WFM_ENTITY_STAGE_DTL_2) violated - parent key not found
- ORA-06512: at line 13
DM 188.8.131.52.0 was installed
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