My Oracle Support Banner

Cannot Generate Rates for Hybrid IRC Error in fsapps.log Showing ORA-01720 (Doc ID 2928180.1)

Last updated on FEBRUARY 22, 2023

Applies to:

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

Symptoms

Unable to generate rates for Hybrid Interest Rate Code (IRC) which are configured as spread between two IRCs. There is a popup message saying successfully triggered the generation process but no records are getting inserted into FSI_IRC_RATE_HIST table nor able to see the newly generated rates data on the User Interface (UI).

Error:
Web server fsapps.log shows error below on generateHybridCodes:

[ERROR] [WEB] [FSAPPS] com.ofs.fsapps.commonapps.irc.dao.InterestRateDAO Exception in saveInterestRateDefintion java.sql.SQLSyntaxErrorException:
ORA-01720: grant option does not exist for 'SYS.DUAL'
ORA-06512: at "FSI_IRC_HYBRID_SPREAD_LINEAR", line 651
ORA-06512: at "FSI_IRC_HYBRID_SPREAD_LINEAR", line 565
ORA-06512: at line 1

Steps To Replicate:
1. Create a new Hybrid IRC to generate weekly hybrid rates as spread between two IRCs.
2. Select Start Date and End Date within one month period.
3. Click Generate Rates and popup message shown successfully triggered the generation process.
4. No newly generated rates shown on the UI.
5. No records is inserted in FSI_IRC_RATE_HIST.
6. Found error message in web server fsapps.log on generateHybridCodes.

Changes

 

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