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

Posted by IKV on Mar 23, 2015; 8:04pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/12-2-4-Remove-custom-application-registered-using-the-Application-Register-screen-tp193p232.html

Erman, thanks for the inputs. I did a trace and below is an excerpt from the trace file.
The program is very basic - it is only creating a log and an output file. There are no custom objects involved so grants and synonyms are out of picture.

----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=4d8w3n5u1mgp3) -----
LOCK TABLE FND_CONCURRENT_PROCESSES IN SHARE UPDATE MODE NOWAIT

----- Error Stack Dump -----
ORA-00942: table or view does not exist
----- Current SQL Statement for this session (sql_id=4d8w3n5u1mgp3) -----
LOCK TABLE FND_CONCURRENT_PROCESSES IN SHARE UPDATE MODE NOWAIT

----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=fmfdkztk8vx23) -----
SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE  = :B3 AND ROWNUM  = 1

----- Error Stack Dump -----
ORA-00942: table or view does not exist
----- Current SQL Statement for this session (sql_id=fmfdkztk8vx23) -----
SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE  = :B3 AND ROWNUM  = 1