Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Upgraded EBS Database 12.1.0.2 to 19.3.0.0 but missing views APPS.v$parameter and APPS.v$parameter2

edited Aug 20, 2021 10:25AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 comments

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

Tagged:

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center