oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • OAF:Need sugession
    via by A.T,
  • Error in simple form
    via by 534328,
  • Nullpointerexception ....
    via by 572444,
  • Delete Personalization
    via by 552232,
  • Details PAge issues
    via by Rakesh S,
  • Assigning SPEL values
    via by sreese,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CarrirerAppEO.APPOINTMENT_DATE, CarrirerAppEO.WAREHOUSE, CarrirerAppEO.STATUS, CarrirerAppEO.PO, CarrirerAppEO.CANCEL_DATE, CarrirerAppEO.TRIP, CarrirerAppEO.DELIV_DATETIME, CarrirerAppEO.TENDERDATE_TIME, CarrirerAppEO.BOL, CarrirerAppEO.WALMART_LOAD_NUM, CarrirerAppEO.CITY_SATE, CarrirerAppEO.CITY, CarrirerAppEO.STATE, CarrirerAppEO.CARRIER, CarrirerAppEO.TEAM_TIME, CarrirerAppEO.LOAD_AUT_NUM, CarrirerAppEO.BROKER, CarrirerAppEO.TRAILER_NUM, CarrirerAppEO.FORKLIFT_DRIVER_ID, CarrirerAppEO.DOCK_NUM, CarrirerAppEO.TIME_IN, CarrirerAppEO.START_TIME, CarrirerAppEO.END_TIME, CarrirerAppEO.TIME_OUT, CarrirerAppEO.APPT_TIME, CarrirerAppEO.COMMENTS, CarrirerAppEO.CUSTOMER_NAME, CarrirerAppEO.DISPATCH_OFFICE, CarrirerAppEO.REASON_CODE, CarrirerAppEO.CREATION_DATE, CarrirerAppEO.CREATED_BY, CarrirerAppEO.LAST_UPDATE_DATE, CarrirerAppEO.LAST_UPDATED_BY, CarrirerAppEO.ORDER_NUMBER, CarrirerAppEO.CREATION_METHOD, CarrirerAppEO.TRUCK_CATEGORY, CarrirerAppEO.TRUCK_TYPE, CarrirerAppEO.LOAD_TYPE, CarrirerAppEO.LOAD_METHOD, CarrirerAppEO.CARRIER_APP_ID, CarrirerAppEO.ORG_ID, CarrirerAppEO.SHIP_METHOD_CODE, CarrirerAppEO.OBJECT_VERSION_NUMBER, CarrirerAppEO.CUST_LOAD_NUM FROM IGL_CARRIER_APPOINTMENTS CarrirerAppEO at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:152) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:721) at gwp.oracle.apps.xxi.carriers.webui.LoadSearchPGCO.processFormRequest(LoadSearchPGCO.java:56) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2633) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    10 more bugmates