Job status 'Aborted' with ORA-20096 error message

Document ID : KB000089921
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Job status 'Aborted' with ORA-20096 error message
Resolution:
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.
Investigation

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.
Solution

Change value of parameter '<NO PENDING JOBS ALLOWED>'.