Claims Patch 4.23.2.0.0 Failed with Error: ORA-01430: column being added already exists in table (Doc ID 3048452.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Symptoms

OHIDEV5 Patch 4.23.2.0.0 failed

GENERAL INFORMATION
=====================

OHI Product: Oracle Health Insurance Claims Adjudication
OHI Component: Claims Administration
OHI Version: 4.23.1.0.5
Problem first noticed: while triggering the update.sh to apply 4.23.2.0.0 patch from 4.23.1.0.5



Patch 4.23.2.0.0 failed when upgrading from patch from 4.23.1.0.5

Triggered update.sh to apply the patch and received the following error in the install.log:

Error:
[Sun Sep 01 06:48:07 EDT 2024] [SEVERE] Exception Details: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset 2023-11-20_NXT-27567.xml::1::sanmeda:
Reason: liquibase.exception.DatabaseException: ORA-01430: column being added already exists in table
[Failed SQL: (1430) ALTER TABLE CLA_CLAIM_LINE_BENEFIT_SPECS ADD EVALUATION_RESULT VARCHAR2(1 CHAR)]
...
[Mon Sep 09 04:10:04 EDT 2024] [SEVERE] Exception Details: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset 2024-05-03_NXT_29107_RCL_ PROD_BEN_SPEC_LIMITS_B.xml::1::vnunemun:
  Reason: liquibase.exception.DatabaseException: ORA-01430: column being added already exists in table
 [Failed SQL: (1430) ALTER TABLE RCL_PROD_BEN_SPEC_LIMITS_B ADD IND_EXCLUDE_FROM_CARRY_OVER VARCHAR2(1 CHAR)]

Changes

Cause

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