Prepare phase failed ORA-00904: "TABTYPE": invalid identifier

Posted by satish on Aug 23, 2023; 6:50am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Prepare-phase-failed-ORA-00904-TABTYPE-invalid-identifier-tp12029.html

Hello Erman,

We are on R12.2.5 and database version 19.17
OS RHEL 7.9

Prepare phase failed while running autoconfig.
From the log,we could see below error for all the below scripts.

ORA-00904: "TABTYPE": invalid identifier
ORA-06512: at "APPS.ADX_PRF_PKG", line 81
ORA-06512: at line 6

Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/txkappsprf.sql
Error encountered while running afadmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/afwebprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/amscmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/amswebprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/wshadmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/clnadmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/oksfrmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/csfadmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/cncmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/csiadmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/cseadmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/eamadmprf.sql
Error encountered while running /u02/SUPPDBINST/fs1/inst/apps/SUPPDB_erpsupport/admin/install/fteadmprf.sql
[applsupp@erpsupport ~]$


We tried below action plan,but didnt work

1. Run adadmin–>Recreate Grants and Synonyms
2. Compile Apps Schema

Any help please?

Thank You,
SG