Interest Rates Edit Screen Error Shows Throws Error Invalid Key: 13085 (Doc ID 2593061.1)

Last updated on APRIL 26, 2023

Applies to:

Symptoms

Unable to open Rate Management > Interest Rates screen in 8.0.7, throws error below.
The same error also occurs when editing existing Interest Rates after changing the Global Preference Date format from MM/DD/YYYY or MM/DD/YY to other formats ie: dd-MMM-yy.

Error:

Invalid Key : 13085

fsapps.log shows:
[ERROR] [WEB] [FSAPPS] com.ofs.fsapps.commonapps.irc.dao.InterestRateDAO Exception in getRateHistory: java.sql.SQLDataException: ORA-01821: date format not recognized

[ERROR] [WEB] [FSAPPS] com.ofs.fsapps.commonapps.irc.rest.InterestRateController com.ofs.fsapps.commonapps.irc.exception.InterestRateException
com.ofs.fsapps.commonapps.irc.exception.InterestRateException: null

[ERROR] [WEB] [FSAPPS] [com.ofs.fsapps.commonapps.util.errormessages.ErrorMessagesDAO: fetchErrorMessages] : Exception : Message or values format is not correct java.lang.Exception: Invalid Key : 13085
java.lang.Exception: Invalid Key : 13085
at com.ofs.fsapps.commonapps.util.errormessages.ErrorMessagesDAO.getMessages(ErrorMessagesDAO.java:222) ~[commonapps_core-ws.jar:?]

Steps to Replicate:
1. Upgraded Oracle Financial Services Analytical Applications (OFSAA) from 8.0.4 to 8.0.7.
2. Opened an existing Interest Rate Code and received the above error.
3. Created a new Interest Rate Code and received the same error.

Changes

Cause

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