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.

Symptoms

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

oracle.jbo.sqlstmtexception-jbo-27120

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 <<Note:144826.1>>), 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

Changes

Upgraded to OFSA 4.5.

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