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

Posted by ErmanArslansOracleBlog on Aug 25, 2023; 5:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Prepare-phase-failed-ORA-00904-TABTYPE-invalid-identifier-tp12029p12033.html

The issue is not related with "ADX_PRE_AUTOCONFIG"..  Table ADX_PRE_AUTOCONFIG will be created when the autoconfig is run..
So it is not that.. The cause is the tabtype..
The problem is related with the "tab" table.. IT is a dictionary table, and probably, tabtype column is not present in the definition of that table.

What columns do that "tab" table have in this problematic env?

What columns do you see when you run select * from tab (with apps user)

"Tab" should be a dictionary view.. I suspect there is a missing grant issue here..

Also compare the following;

*APPS privileges between your problematic and problem-free environments
*dictionary table "tab" definition between your problematic and problem-free environments

These comparisons and check will tell you something..