APP-FND-01564 Oracle error - 20160 in SUBMIT

ORA-4091 applsys.fnd_concurrent_requests is mutating trigger/function may not see it.

Solution Description :

--------------------------

You need to disable the event alert trigger going against the 

fnd_concurrent_requests table, and create a periodic alert instead.

*The trigger will be named ALR_<table_name>_IAR for insert and 

ALR_<table_name>_UAR for update.*  Make the changes as follows:

 1.  Login to sqlplus as APPS.

   2.  Disable the trigger:

   sqlplus> alter trigger triggername disable;

   e.g.

   sqlplus> alter trigger ALR_FND_CONCURRENT_REQUESTS_UAR disable;

   3.  Create a new PERIODIC alert (cannot just convert Event to Periodic) on 

       FND_CONCURRENT_REQUESTS and set the frequency of the Alert according to 

       your business need - e.g. once per business day.  This will allow a 

       single email to report multiple request information as specified in the 

       sql select statement.

++++++++++++++++++++++++++++++++++++++++

ID : 1012483.102
++++++++++++++++++++++++++++++++++++++++