My Oracle Support Banner

New Fields In Patch Without ERWIN (Doc ID 2923572.1)

Last updated on JANUARY 31, 2023

Applies to:

Oracle Insurance Accounting Analyzer - Version 8.0.6 and later
Information in this document applies to any platform.

Goal

While installing the below patches in a Development environment.:
- 8.1.2.1.2 - Patch 34567121
- 8.1.2.1.3 - Patch 34689758

First patch has as pre-installation steps to update OOB data model in order to include following new fields (see PreRequisites_34567121.txt file): V_CALC_METHOD and V_TRANS_APPROACH in STG_INS_GROUP_DIMENSION_MAP table and N_CALC_METHOD and N_TRANS_APPROACH in FSI_CSM_GROUP_DIMENSION_MAP table.

Can the above fields be updated manually with below statements, if the Erwin tool is not available:

ALTER TABLE STG_INS_GROUP_DIMENSION_MAP ADD (V_CALC_METHOD VARCHAR2(10 CHAR) DEFAULT NULL);
ALTER TABLE STG_INS_GROUP_DIMENSION_MAP ADD (V_TRANS_APPROACH VARCHAR2(10 CHAR) DEFAULT NULL);

ALTER TABLE FSI_CSM_GROUP_DIMENSION_MAP ADD (N_CALC_METHOD NUMBER(5) DEFAULT NULL);
ALTER TABLE FSI_CSM_GROUP_DIMENSION_MAP ADD (N_TRANS_APPROACH NUMBER(5) DEFAULT NULL);
 

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


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