Re: 12.2.4 Remove custom application registered using the Application>Register screen

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/12-2-4-Remove-custom-application-registered-using-the-Application-Register-screen-tp193p233.html

Okay...
So ORa-00942 shows that your custom database user which is associated with the data group, does not have necessary privileges to operate on table such as : FND_CONCURRENT_PROCESSES and FND_NEW_MESSAGES... There may be other tables too..

So, that s why the standart way is to use apps as oracle_id  when adding a custom schema to a data
group.

You can grant those privileges, but then you will end up a custom schema with bunch of privileges.. You may not want this.. That 's my go with APPS as oracle_id