My Oracle Support Banner

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

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
Symptoms
Cause
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.