ORA-00942 on OFSA_DB_INFO Logging in as Non OFSA Schema Owner

(Doc ID 250072.1)

Last updated on DECEMBER 12, 2016

Applies to:

Oracle Financial Data Manager - Version: 4.5 to 4.5.39 - Release: 4.5 to 4.5
Oracle Transfer Pricing - Version: 4.5 to 4.5.39   [Release: 4.5 to 4.5]
Oracle Profitability Manager - Version: 4.5 to 4.5.39   [Release: 4.5 to 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer (PA) - Version: 4.5 to 4.5.39
TP
BC
RM
Checked for relevance 07-Nov-2011.

Symptoms

You cannot log into an Oracle Financial Services Applications (OFSA) module as a regular,  non-OFSA schema owner user.  You receive the following error when logging in:

(203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
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
_$#$_

Followed by:

(203055) Error LoadStart() : Execute() SQL statement.

Followed by:

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

You can log into SQL*Plus successfully.  You can log into the OFSA module as the OFSA database owner.

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