'ORA-00904: "A"."HOLIDAY_CALC_OPTION_CD": Invalid Identifier' During ALM 6.1 Installation

(Doc ID 1684863.1)

Last updated on JUNE 23, 2014

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When installing Oracle Financial Services Asset Liability Management (ALM) 6.1, you get the following error in the installation log:

[Mon 19/5/2014 09:10:41] [OFSALM] [DEBUG] - ===>Executing file:/app/ofsapp/ofs/scripts/atomic/create/dm_alm_views_ddl.sql
[Mon 19/5/2014 09:10:41] [OFSALM] [ERROR] - Query:'CREATE OR REPLACE VIEW FSI_M_PROD_CHARACTERISTICS_V
AS SELECT
a.PROD_CHAR_SYS_ID AS PROD_CHAR_SYS_ID,
a.PRODUCT_ID AS PRODUCT_ID,
a.CCY_CD AS CCY_CD,
a.GROSS_RATES_FLG AS GROSS_RATES_FLG,
a.OPT_ADJ_SPREAD AS OPT_ADJ_SPREAD,
a.CCY_GAIN_LOSS_BASIS AS CCY_GAIN_LOSS_BASIS,
a.CAL_ROLLING_CONVENTION_CD AS CAL_ROLLING_CONVENTION_CD,
a.INT_CRDT_FLG AS INT_CRDT_FLG,
a.PCT_TAX AS PCT_TAX,
a.PAY_EQUI_COMPOUND_CONV_CD AS PAY_EQUI_COMPOUND_CONV_CD ,
a.AMORT_METHOD_CD AS AMORT_METHOD_CD,
GREATEST(COALESCE(a.AMORT_TYPE, 0), COALESCE(a.PAYMENT_PATTERN_CD, 0), COALESCE(a.BEHAVIOUR_PATTERN_CD, 0)) AS AMORT_TYPE,
a.ORG_DEF_AMORT_PCT AS ORG_DEF_AMORT_PCT,
a.PMT_FREQ AS PMT_FREQ,
a.PMT_FREQ_MULTIPLIER AS PMT_FREQ_MULTIPLIER,
a.INT_TYPE AS INT_TYPE,
a.NET_MARGIN_FLG AS NET_MARGIN_FLG,
a.REP_FREQ AS REP_FREQ,
a.REP_FREQ_MULTIPLIER AS REP_FREQ_MULTIPLIER,
a.TEASE_PERIOD AS TEASE_PERIOD,
a.TEASE_PERIOD_MULTIPLIER AS TEASE_PERIOD_MULTIPLIER,
a.TEASE_DISCOUNT AS TEASE_DISCOUNT,
a.RATE_CAP_LIFE AS RATE_CAP_LIFE,
a.RATE_SET_LAG AS RATE_SET_LAG,
a.RATE_SET_LAG_MULTIPLIER AS RATE_SET_LAG_MULTIPLIER,
a.RATE_CHG_ROUND_PCT AS RATE_CHG_ROUND_PCT,
a.RATE_CHG_ROUND_TYPE AS RATE_CHG_ROUND_TYPE,
a.RATE_INC_PERIOD AS RATE_INC_PERIOD,
a.RATE_DEC_PERIOD AS RATE_DEC_PERIOD,
a.RATE_FLOOR_LIFE AS RATE_FLOOR_LIFE,
a.RATE_INC_LIFE AS RATE_INC_LIFE,
a.RATE_DEC_LIFE AS RATE_DEC_LIFE,
a.PMT_CHG_FREQ AS PMT_CHG_FREQ,
a.PMT_CHG_FREQ_MULTIPLIER AS PMT_CHG_FREQ_MULTIPLIER,
a.NEG_AMORT_EQ_FREQ AS NEG_AMORT_EQ_FREQ,
a.NEG_AMORT_EQ_FREQ_MULTIPLIER AS NEG_AMORT_EQ_FREQ_MULTIPLIER,
a.PMT_DEC_LIFE AS PMT_DEC_LIFE,
a.PMT_DEC_PERIOD AS PMT_DEC_PERIOD,
a.NEG_AMORT_EQ_LIMIT AS NEG_AMORT_EQ_LIMIT,
a.PMT_INC_LIFE AS PMT_INC_LIFE,
a.PMT_INC_PERIOD AS PMT_INC_PERIOD,
a.ORIGINAL_TERM AS ORIGINAL_TERM,
a.ORIGINAL_TERM_MULT AS ORIGINAL_TERM_MULT,
a.AMRT_TERM AS AMRT_TERM,
a.AMRT_TERM_MULT AS AMRT_TERM_MULT,
a.ACCR_BASIS AS ACCR_BASIS,
GREATEST(COALESCE(a.ADJ_TYPE, 0), COALESCE(a.REPRICING_PATTERN_CD, 0)) AS ADJ_TYPE,
a.INTEREST_RATE_CD AS INTEREST_RATE_CD,
a.MARGIN AS MARGIN,
a.MIN_RATE_CHANGE AS MIN_RATE_CHANGE,
a.COMP_BASIS AS COMP_BASIS,
a.LEASE_RESIDUAL_PCT,
a.HOLIDAY_CALENDAR_CODE,
a.HOLIDAY_CALC_OPTION_CD
FROM FSI_M_PROD_CHARACTERISTICS a
ORDER BY a.PROD_CHAR_SYS_ID'
Error:ORA-00904: "A"."HOLIDAY_CALC_OPTION_CD": invalid identifier

The error prevents the view FSI_M_PROD_CHARACTERISTICS_V from being created.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms