You have encountered an unexpected error. Please contact the System Administrator for assistance with error oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION

ISSUE:

You have encountered an unexpected error. Please contact the System Administrator for assistance.

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)

CAUSE:

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

sh adstrtal.sh and Test again.

Permanent fix:

For permanent fix apply the below patch.

12.1.2 and 12.1.1 Customers apply and test Patch: 9908921

Release 12.1.3 Customers apply and test Patch: 11832737

Reference: 1298103.1