OFSA_DBINFO_UTIL Package Body Invalid After Installation of OFSA (Doc ID 1081065.1)

Last updated on APRIL 05, 2010

Applies to:

Oracle Financial Data Manager - Version: 4.5.39 - Release: 4.5
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39

Symptoms

When attempting to re-compile OFSA_DBINFO_UTILS after OFSA 4.5.39 installation, the following error occurs.

Error
Package body OFSA_DBINFO_UTILS@schema@owner
Error(65,4): PL/SQL: SQL Statement ignored
Error(65,36): PLS-00201: identifier 'V$DATABASE' must be declared

Steps
1. Installed OFSA 4.5.39 on RDBMS 11.1.0.6.0
2. Checked for Invalid Objects and found OFSA_DBINFO_UTILS package body is invalid.


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