AGIS: Recall/Approve Transaction Raises Error: You Have Encountered An Unexpected Error

(Doc ID 1632307.1)

Last updated on SEPTEMBER 29, 2016

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to recall or approve an AGIS transactions, the following error occurs:


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

Error details show the following:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: Initialization failed;
    at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
    at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
    at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
    at oracle.apps.fun.transaction.entry.webui.OutDistCreateCO.processFormRequest(OutDistCreateCO.java:954)
    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)

...

java.sql.SQLException: Initialization failed
    at oracle.sql.DATE.<init>(DATE.java:233)
    at oracle.jbo.domain.Date.<init>(Date.java:268)
    at oracle.apps.fun.transaction.entry.server.OutBoundAMImpl.onSubmit(OutBoundAMImpl.java:1795)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

...

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

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