APP-FND-01564 Oracle error - 20160 in SUBMIT

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

I faced this issue when i tried creating an event alert on FND_CONCURRENT_REQUESTS table.

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 sql/plus as APPS.
2. Disable the trigger:

sqlplus> alter trigger trigger_name 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.

Challa.