Application: FND, Message Name: FND_NO_DATABASE

Application: FND, Message Name: FND_NO_DATABASE_CONNECTION

ISSUE:

You have encountered an unexpected error. Please contact the System Administrator for assistance when login to EBS R12.1.

Exception details:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION.

error log in oacore log file:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION.

at oracle.apps.fnd.framework.server.OANullDBTransactionImpl.noDatabaseConnection(OANullDBTransactionImpl.java:653)

at oracle.apps.fnd.framework.server.OANullDBTransactionImpl.isLoggingEnabled(OANullDBTransactionImpl.java:930)

at oracle.apps.fnd.framework.OASessionCookieHelper.timeoutApplicationModule(OASessionCookieHelper.java:260)

at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.timeout(OAHttpSessionCookieImpl.java:632)

at oracle.jbo.http.HttpSessionCookieImpl.timeout(HttpSessionCookieImpl.java:160)

at oracle.jbo.http.HttpContainer.fireTimeout(HttpContainer.java:513)

at oracle.jbo.http.HttpContainer.timeout(HttpContainer.java:240)

at oracle.jbo.http.HttpContainer.valueUnbound(HttpContainer.java:299)

at com.evermind.server.http.EvermindHttpSession.destroy(EvermindHttpSession.java:472)

at com.evermind.server.http.HttpApplication.invalidateSession(HttpApplication.java:1007)

at com.evermind.server.http.HttpApplication.invalidateSession(HttpApplication.java:978)

at com.evermind.server.http.EvermindHttpSession.invalidate(EvermindHttpSession.java:411)

at com.evermind.server.http.EvermindHttpSession.invalidate(EvermindHttpSession.java:378)

at com.evermind.server.http.SessionAsyncInvalidateHandler.invalidateSession(SessionAsyncInvalidateHandler.java:159)

at com.evermind.server.http.SessionAsyncInvalidateHandler.run(SessionAsyncInvalidateHandler.java:119)

at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

at java.lang.Thread.run(Thread.java:619)

REASON:

AM Pool created during REST request does not contain the connect string information. When a new AM is requested as part of normal AM checkout, it errors out with FND_NO_DATABASE_CONNECTION.

Resolution: Include connect string information while creating AM Pool for REST invocation.

SOLUTION:

Work around

Restart the applications

cd $ADMIN_SCRIPTS_HOME

sh adstpall.sh

Wait for all processes to clear.

sh adstrtal.sh and Test again.

Permanent fix:

For permanent fix apply the below patch.

12.1.2 and 12.1.1 apply and test Patch: 9908921

Release 12.1.3 apply and test Patch: 11832737

Reference: R12: Login Fails Intermittently With Error "oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION" (Doc ID 1298103.1)