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.

  • Error while loading RTF template
    via by user588642,
  • Invalid Index Error....
    via by 619461,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ExpenseReportLineEO.REPORT_LINE_ID, ExpenseReportLineEO.FLEX_CONCATENATED, ExpenseReportLineEO.START_EXPENSE_DATE, ExpenseReportLineEO.END_EXPENSE_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_AMOUNT, ExpenseReportLineEO.AMOUNT, ExpenseReportLineEO.CURRENCY_CODE, ExpenseReportLineEO.MERCHANT_NAME, ExpenseReportLineEO.LOCATION, ExpenseReportLineEO.ALLOCATION_REASON, ExpenseReportLineEO.JUSTIFICATION, ExpenseReportLineEO.CODE_COMBINATION_ID, ExpenseReportLineEO.REPORT_HEADER_ID, ExpenseReportLineEO.WEB_PARAMETER_ID, ExpenseReportLineEO.ORG_ID, ExpenseReportLineEO.DISTRIBUTION_LINE_NUMBER, ExpenseReportLineEO.PROJECT_ID, ExpenseReportLineEO.TASK_ID, ExpenseReportLineEO.AWARD_ID, ExpenseReportLineEO.EXPENDITURE_ORGANIZATION_ID, ExpenseReportLineEO.PROJECT_NUMBER, ExpenseReportLineEO.TASK_NUMBER, ExpenseReportLineEO.AWARD_NUMBER, ExpenseReportLineEO.CURRENCY_CODE AS CURRENCY_CODE1, ExpenseReportLineEO.CATEGORY_CODE, ExpenseReportLineEO.CREDIT_CARD_TRX_ID, ExpenseReportLineEO.ALLOCATION_SPLIT_CODE, ExpenseReportLineEO.EXPENDITURE_TYPE, ExpenseReportLineEO.EXPENDITURE_ITEM_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_CODE, ExpenseReportLineEO.ITEMIZATION_PARENT_ID, ExpenseReportLineEO.ATTRIBUTE3, ExpenseReportLineEO.LAST_UPDATE_DATE FROM AP_EXPENSE_REPORT_LINES_ALL ExpenseReportLineEO WHERE (itemization_parent_id IS NULL OR itemization_parent_id 0) AND NOT EXISTS (SELECT 1 FROM ap_expense_report_params_all WHERE expense_type_code in ('ROUNDING', 'PERSONAL') AND parameter_id = ExpenseReportLineEO.web_parameter_id) AND :1 = ExpenseReportLineEO.REPORT_HEADER_ID AND ExpenseReportLineEO.FLEX_CONCATENATED='Y' ORDER BY distribution_line_number at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993) 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.ap.oie.entry.accounting.webui.AllocationsHGridCO.processRequest(AllocationsHGridCO.java:187) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596) at oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2136) at oracle.apps.fnd.framework.webui.OAWebBeanHGridHelper.processRequest(OAWebBeanHGridHelper.java:1643) at oracle.apps.fnd.framework.webui.beans.table.OAHGridBean.processRequest(OAHGridBean.java:688) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2491) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1889) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:533) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:421)

    Users with the same issue

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