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)))))))))))

Oracle Community | 907823 | 4 years ago
  1. 0

    Attempt to set a parameter name that does not occur in the SQL: 1

    Oracle Community | 4 years ago | 907823
    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)))))))))))
  2. 0

    Fnd Load Issue

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;
  3. 0

    db:: 3.55::FND_MESSAGE.PUT 1c

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SEPL and VO Extension

    Oracle Community | 9 years ago | 567494
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = xxEYReqSummaryVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
  6. 0

    Tycast error in Extension

    Oracle Community | 8 years ago | 568541
    oracle.apps.fnd.framework.OAException: The application id or shortname (abc) you entered does not exist.

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616)
      3. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      4. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      5. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      8. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      9. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      10. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      13. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      14. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      15. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      16. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1786)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      19. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      19 frames