Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

EBS Database Upgrade From Version 12.1.0.2 To 19.9.0.0.0 (19C) is failing at Phase #99.

edited Nov 23, 2020 8:27PM in Database Install/Upgrade/Opatch (MOSC) 5 comments

Hello All,

I am trying to upgrade EBS database from 12.1.0.2 To 19.9.0.0.0 . I am stuck at Phase#99 with the below error message, Upon, further analysis, it seems the Phase#99 sql (catmmig.sql ) is failing because of invalid VIEWS.

a)DBA_TAB_COLS_V$

The above VIEW is invalid due to the below error. I believe the column name "COLLINTCOL#" in the below message has been newly introduces during upgrade.

Query: select text from all_errors where owner = 'SYS' and type = 'VIEW' and name = 'DBA_TAB_COLS_V$';

Query Result: ORA-00904: "C"."COLLINTCOL#": invalid identifier

Instance Details:

EBS Version: EBS R12.2.10.

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