Interest Rates Page is Giving Error While Loading - "Not able to execute the query for module Id_Type: INT_RATE_ALM" (Doc ID 2195357.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.0.3 and later
Oracle Financial Services Asset Liability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
OFSAA - Oracle Financial Services Analytical Applications
OFSAAI- Oracle Financial Services Analytical Applications Infrastructure
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On OFSAA 6.1.0.3, the Interest Rates page is giving error while loading:

ERROR

Not able to execute the query for module Id_Type: INT_RATE_ALM: infodom: OFSAAA
Query:select INTEREST_RATE_CD "44",IRC_NAME "1",fsi_irc_format_mls.IRC_FORMAT "41",fsi_compound_basis_mls.COMPOUND_BASIS "36", fsi_accrual_basis_mls.ACCRUAL_BASIS "34",fsi_currency_mls.currency_name "43", DECODE(fsi_ircs.VOLATILITY_CURVE_FLG, 0, tl.lookup_description, 1, tl.lookup_description) "202", CREATED_DATE "9",CREATED_BY "8", LAST_MODIFIED_DATE "11", LAST_MODIFIED_BY "10", INTEREST_RATE_CD "PrimaryKey", '200~' || IRC_DESC "DBToolText" from fsi_m_lookup_tl tl, fsi_ircs left join fsi_irc_format_mls on fsi_ircs.IRC_FORMAT_CD = fsi_irc_format_mls.IRC_FORMAT_CD and fsi_irc_format_mls.mls_cd='US' left join fsi_accrual_basis_mls on fsi_ircs.ACCRUAL_BASIS_CD = fsi_accrual_basis_mls.ACCRUAL_BASIS_CD and fsi_accrual_basis_mls.mls_cd='US' left join fsi_compound_basis_mls on fsi_ircs.COMPOUND_BASIS_CD = fsi_compound_basis_mls.COMPOUND_BASIS_CD and fsi_compound_basis_mls.mls_cd='US' left join fsi_currency_mls on fsi_ircs.iso_currency_cd = fsi_currency_mls.iso_currency_cd and fsi_currency_mls.mls_cd='US' where fsi_ircs.Irc_Structure_Type is not null and fsi_ircs.VOLATILITY_CURVE_FLG = tl.LOOKUP_CD and tl.CATEGORY_ID = 207 and tl.LANG_CODE = 'US'


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