EBS Database Upgrade From Version 12.1.0.2 To 19.9.0.0.0 (19C) is failing at Phase #99.
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.