ORA-00942 on OFSA_DB_INFO Logging in as Non OFSA Schema Owner
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
Checked for relevance 07-Nov-2011.
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:  - oexec(), oexn()
SQL Function:  - 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_$#$_
(203055) Error LoadStart() : Execute() SQL statement.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms