oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT flv.lookup_code, flv.lookup_type, flv.meaning FROM fnd_lookup_values_vl flv WHERE lookup_type = 'INL_SHIP_TASKS' AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL((TRUNC(start_date_active)),SYSDATE) AND NVL((TRUNC(end_date_active)+.99999)-1,SYSDATE) AND lookup_code IN ('GENERATE_CHARGE','TAXATION', 'VALIDATION', 'CALCULATION', 'SUBMIT', 'MANAGE_ASSOC', 'MANAGE_CHARGE','SEPARATOR_10', 'VIEW_LANDEDCOST', 'SEPARATOR_20', 'SEPARATOR_30')) QRSLT WHERE (lookup_code NOT IN ( 'SUBMIT')) ORDER BY DECODE(lookup_code, 'GENERATE_CHARGE', 0, DECODE(LOOKUP_CODE, 'TAXATION', 1, DECODE(LOOKUP_CODE, 'SEPARATOR_10', 2, DECODE(LOOKUP_CODE, 'VALIDATION', 3, DECODE(LOOKUP_CODE, 'CALCULATION',4, DECODE(LOOKUP_CODE, 'SUBMIT',5, DECODE(LOOKUP_CODE, 'SEPARATOR_20',6, DECODE(LOOKUP_CODE, 'MANAGE_CHARGE',7, DECODE(LOOKUP_CODE, 'MANAGE_ASSOC',8, DECODE(LOOKUP_CODE, 'SEPARATOR_30', 9, DECODE(LOOKUP_CODE, 'VIEW_LANDEDCOST',10,11)))))))))))

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1658

  • via Unknown by Unknown author,
  • via Unknown by 567494,
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT flv.lookup_code, flv.lookup_type, flv.meaning FROM fnd_lookup_values_vl flv WHERE lookup_type = 'INL_SHIP_TASKS' AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL((TRUNC(start_date_active)),SYSDATE) AND NVL((TRUNC(end_date_active)+.99999)-1,SYSDATE) AND lookup_code IN ('GENERATE_CHARGE','TAXATION', 'VALIDATION', 'CALCULATION', 'SUBMIT', 'MANAGE_ASSOC', 'MANAGE_CHARGE','SEPARATOR_10', 'VIEW_LANDEDCOST', 'SEPARATOR_20', 'SEPARATOR_30')) QRSLT WHERE (lookup_code NOT IN ( 'SUBMIT')) ORDER BY DECODE(lookup_code, 'GENERATE_CHARGE', 0, DECODE(LOOKUP_CODE, 'TAXATION', 1, DECODE(LOOKUP_CODE, 'SEPARATOR_10', 2, DECODE(LOOKUP_CODE, 'VALIDATION', 3, DECODE(LOOKUP_CODE, 'CALCULATION',4, DECODE(LOOKUP_CODE, 'SUBMIT',5, DECODE(LOOKUP_CODE, 'SEPARATOR_20',6, DECODE(LOOKUP_CODE, 'MANAGE_CHARGE',7, DECODE(LOOKUP_CODE, 'MANAGE_ASSOC',8, DECODE(LOOKUP_CODE, 'SEPARATOR_30', 9, DECODE(LOOKUP_CODE, 'VIEW_LANDEDCOST',10,11))))))))))) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1786) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    14 more bugmates