ORA-00942 on OFSA_DB_INFO When Logging into OFSA (Doc ID 281998.1)

Last updated on DECEMBER 13, 2007

Applies to:

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

Symptoms

You cannot log into an OFSA module (Balance & Control, Performance Analyzer, Transfer Pricing, etc.). You receive the following error even when logging in as the OFSA database owner:

Oracle error: ORA-00942: table or view does not exist

Driver function: drv_oci: Execute()

SQL statement: select count(OFSA_DB_INFO.owner) FROM OFSA_DB_INFO

After clicking on OK for the error message, you get the following message:

Invalid schema owner... please use a valid database.

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