Performance - EBS (MOSC)

MOSC Banner

PLS-00201: identifier 'V$SYSTEM_PARAMETER2' must be declared

1) SR#: 3-26196038441

2) Customer: National Roads and Motorists' Association Limited

3) Oracle Apps Version: 12.2.9

4) Error(s):

5) Problem Description/Question:

Why are we hitting the below error:

6507/19 PLS-00201: identifier 'V$SYSTEM_PARAMETER2' must be declared

6) Steps taken to debug issue:

Ensured that Customer downloaded the latest code again but issue remains as seen below:


I downloaded the latest code

SQL> @db_statistics_analyzer.sql

PL/SQL procedure successfully completed.

Package created

No errors.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DB_PERFORMANCE_ANALYZER_PKG:

LINE/COL ERROR

-------- -----------------------------------------------------------------

0/0   PL/SQL: Compilation unit analysis terminated

6507/19 PLS-00201: identifier 'V$SYSTEM_PARAMETER2' must be declared

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center