Upgraded EBS Database 12.1.0.2 to 19.3.0.0 but missing views APPS.v$parameter and APPS.v$parameter2
Hi,
I have upgraded my EBS database 12.1.0.2 to 19.3.0.0 and I have the following issues:
1) I dont have the apps.v$parameter and apps.v$parameter2.
select value from APPS.v$parameter where name='utl_file_dir'
*
ERROR at line 1:
ORA-00942: table or view does not exist
When I put UTL_FILE_DIR in the 19c database init.ora file it is ignored as being obsolete.
I have the following:
select * from apps.ebs_utlfile_param;
NUM NAME TYPE VALUE
[NULL] utl_file_dir [NULL] /app/applmgr/IMM25D/fs1/inst/apps/IMM25D_acacdvimmsap05/appltmp,/app/oracle/IMM25D/db/tech_st/temp/IMM25D,/app/oracle/IMM25D/db/tech_st/19.3.0.0/appsutil/outbound/IMM25D_acacdvimmsdb05