Error on MAPPER_PREFERENCES Object When Login to Infrastructure (Doc ID 1076483.1)

Last updated on MARCH 23, 2010

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 - Release: 7
Information in this document applies to any platform.
OFSAA
OFSAAI

Symptoms

When attempting to login to the Infrastructure Application through the User Interface, the following error occurs in revappserver.log even though the login was successful.

Error:
Error: ORA-00942: table or view does not exist Driver [oracle.jdbc.driver.OracleDriver] URL [jdbc:oracle:thin:@ofsaa.support.com:1521:ofsaa] User [config];
Query [select V_MP_MAPPER_CODE, N_MP_VERSION , V_MP_MODIFIED_DATE, V_MP_USER_CHOICE 
from MAPPER_PREFERENCES 
where V_MP_USER_ID='SYSADMN' 
order by V_MP_MAPPER_CODE, N_MP_VERSION, V_MP_MODIFIED_DATE, N_MP_ORDER]

Steps:
1. Login to the Infrastructure Application User Interface successfully.
2. Checked error in revappserver.log and found the above error.

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