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

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

Hi Erman,

We are encountering an issue which might be related to the way the custom application was registered, so posting this here.

Some of the custom programs that are run via the custom application are completing in error.
They run for a while and complete in error with the completion text "Concurrent program returned no reason for failure".
The concurrent manger log shows the below error:

"Call to establish_mgr failed
When reconnecting for request id (524808)
APP-FND-01564: ORACLE error 942 in establish_mgr

Cause: establish_mgr failed due to ORA-00942: table or view does not exist"

I noticed that the custom application is added to the Standard Data Group with the custom Oracle ID (custom schema user) and not APPS.
We recently setup a new testing instance where the custom application was registered the correct way (using adsplice) and there the Oracle ID (for custom app under Standard Data Group) is APPS.

Could this be the reason for the programs not running? And if so, then is there a way to change the Oracle ID to APPS? The Data Group setup screen is not editable.