Error Logging into Rate Manager: oracle.jbo.sqlstmtexception-jbo-27120

(Doc ID 390684.1)

Last updated on OCTOBER 11, 2006

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5
Oracle Rate Manager 4.5 - Version: 4.5
This problem can occur on any platform.


An error occurs when a user logs into into Oracle Rate Manager. After entering the logon information, the following error appears:


The user can get into and use Rate Manager after the error occurs. Other users can access Rate Manager without getting the error.

After starting Oracle Rate Manager in debug mode (see <>), the log file rated.txt contains the following error:

[84] SELECT IRC_FORMAT_CD, IRC_FORMAT FROM ofsa_irc_format_dsc
[85] ViewUsageHelper.createViewAttributeDefImpls failed...
[86] java.sql.SQLException: ORA-00942: table or view does not exist


Upgraded to OFSA 4.5.


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