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