My Oracle Support Banner

Error Encountered When Installing Patch 13097602 (Doc ID 1443255.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 and later
Information in this document applies to any platform.

Goal

On CC&B v 2.3.1, when applying db portion of patch 13097602, script 13097602_RS1.sql inserts F1_EXT_DATA_AREA_CD into F1_DATA_AREA table, but the field does not exist in the environment, so it throws the following error:

ERROR
-----------------------
- INSERT INTO F1_DATA_AREA(DATA_AREA_CD,OWNER_FLG,F1_EXT_DATA_AREA_CD) VALUES ('C1-MDM2MRBasedSnapshot ' , 'C1 ' , NULL);

--ERROR: ORA-00904: "F1_EXT_DATA_AREA_CD": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 48 in 'INSERT INTO F1_DATA_AREA(DATA_AREA_CD,OWNER_FLG,<*>F1_EXT_DATA_AREA_CD) VALUES ('C1-MDM2MRBasedSnapshot ' , 'C1 ' , NULL)') occurred while executing INSERT INTO F1_DATA_AREA(DATA_AREA_CD,OWNER_FLG,F1_EXT_DATA_AREA_CD) VALUES ('C1-MDM2MRBasedSnapshot ' , 'C1 ' , NULL)

ROLLBACK;

Solution

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
Goal
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.