OBBRN Branch Group Maintenance - Unhandled Exception During Modify (Doc ID 3064158.1)

Last updated on DECEMBER 28, 2024

Applies to:

Symptoms

During Modification in the Branch Group Maintenance Screen in OBBRN, We are getting unhandled exceptions during save.
In logs getting below exception.

It seems the tables BRANCHCOMMON.SRV_TW_BC_BRANCH_GRP_MASTER primary key BRANCHCOMMONSRV_TW_BC_BRANCH_GRP_MASTER_PK01 doesn't have mod_no due to this exception is coming up. Please check and release the fix for this.


Code: 1
Call: INSERT INTO SRV_TW_BC_BRANCH_GRP_MASTER (ACTION, AUTH_STAT, BRANCH_GROUP_CODE, BRANCH_GROUP_DESCRIPTION, CHECKER_DT_STAMP, CHECKER_ID, CHECKER_REMARKS, KEY_ID, MAKER_DT_STAMP, MAKER_ID, MAKER_REMARKS, ONCE_AUTH, RECORD_STAT, MOD_NO, ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [MODIFY, U, TEST, TEST GRP, null, null, null, TEST, 2024-11-21 11:54:46.0, VAIBHAV1, , N, O, 2, 1315549330259447808]
Query: InsertObjectQuery(oracle.fsgbu.obremo.services.srv.branchcommon.maintenance.entity.SrvTwBcBranchGrpMaster@681c27dd); nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.6.v20200131-b7c997804f): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BRANCHCOMMON.SRV_TW_BC_BRANCH_GRP_MASTER_PK01) violated

Error Code: 1
Call: INSERT INTO SRV_TW_BC_BRANCH_GRP_MASTER (ACTION, AUTH_STAT, BRANCH_GROUP_CODE, BRANCH_GROUP_DESCRIPTION, CHECKER_DT_STAMP, CHECKER_ID, CHECKER_REMARKS, KEY_ID, MAKER_DT_STAMP, MAKER_ID, MAKER_REMARKS, ONCE_AUTH, RECORD_STAT, MOD_NO, ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [MODIFY, U, TEST, TEST GRP, null, null, null, TEST, 2024-11-21 11:54:46.0, VAIBHAV1, , N, O, 2, 1315549330259447808]

ERROR
-----------------------
unhandled exception

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to the branch group maintenance screen
2. Take an existing maintenance
3. Do modification and save.

Cause

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