Applicableto Applications Manager version 8.0 and 7.x
Detailed Description and Symptoms
Jobs in a Concurrent Manager instance go to status 'Aborted' immediately and you see an error message like the following:
Error during Job Launch java.sql.SQLException: ORA-20096:
Only one pending Concurrent Request is allowed for TSFTRDCTRL at any given time.
ORA-06512: at "APPS.APPWORX_OAE_PK", line 470
ORA-06512: at line 1
Usually, these issues only happen on one specific Agent and the jobs work normally on other Agents.
Concurrent Manager includes a file called 'FND_CONCURRENT_PROGRAMS'. There is a parameter in this file called '<NO PENDING JOBS ALLOWED>' which has to be investitaged.
Change value of parameter '<NO PENDING JOBS ALLOWED>'.