After upgrade requests fail with Not able to create new database connection: FND SECURITY_APPL_SERVER_ID (Doc ID 1917316.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Concurrent Processing - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

After upgrading from E-Business Suite (EBS) Release 12.0 to 12.2.3, when submitting concurrent requests, the following log file error message occurs.

"Exception in thread "main" oracle.apps.fnd.cache.CacheException
at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:228)
...
Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache:
oracle.apps.fnd.common.PoolException: Not able to create new database connection: FND SECURITY_APPL_SERVER_ID
...
Caused by: oracle.apps.jtf.base.resources.FrameworkException:
An exception occurred in the method CacheAccess.get
null
The base exception is:
Not able to create new database connection: FND SECURITY_APPL_SERVER_ID
"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the concurrent program "Period Close Exceptions Report (XML)" (APXPCER_XMLP)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms