oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT xxscd.CLAIM_ID, xxscd.CLAIM_NUM, xxscd.SUPPLIER_NAME, xxscd.SUPPLIER_ID, xxscd.ADDRESS, xxscd.ADDRESS_ID, xxscd.CLAIM_DATE, flvt.meaning CLAIM_TYPE, xxscd.INVOICE_NUM, xxscd.INVOICE_ID, xxscd.CLOSUER_DATE, xxscd.ORDER_NUM, flvs.meaning STATUS, xxscd.RECEIVING_CHANNEL, xxscd.LEADTIME, xxscd.EMP_ASSIGNED_NAME, xxscd.EMP_ASSIGNED_ID, xxscd.PATTERN, xxscd.SUPPLIER_TYPE, xxscd.DEPARTMENT, xxscd.ORG_ID, xxscd.CREATION_DATE, xxscd.CREATED_BY, xxscd.LAST_UPDATE_DATE, xxscd.LAST_UPDATED_BY, xxscd.LAST_UPDATE_LOGIN, xxscd.AttriBUTE1, xxscd.AttriBUTE2, xxscd.AttriBUTE3, xxscd.AttriBUTE4, xxscd.AttriBUTE5, xxscd.AttriBUTE6, xxscd.AttriBUTE7, xxscd.AttriBUTE8, xxscd.AttriBUTE9, xxscd.AttriBUTE10, xxsnt_claim_upd_enb_disab(STATUS) AS UPDATE_SWITCHER FROM XXSNT_SUPPLIER_CLAIM_DETAILS xxscd, fnd_lookup_values flvt, fnd_lookup_values flvs WHERE ((xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'Y' AND xxscd.status != 'DRAFT') OR (xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'N')) AND xxscd.CLAIM_NUM like NVL(:1, xxscd.CLAIM_NUM) AND flvt.lookup_type(+) = 'XXSNT_SUPPLIER_CLAIM_TYPE' AND flvt.lookup_code(+) = xxscd.CLAIM_TYPE AND flvt.language(+) = userenv('LANG') AND flvs.lookup_type(+) = 'XXSNT_CLAIM_STATUS' AND flvs.lookup_code(+) = xxscd.STATUS AND flvs.language(+) = userenv('LANG') AND xxscd.SUPPLIER_ID = NVL(:2, xxscd.SUPPLIER_ID) AND nvl(xxscd.INVOICE_ID, -999) = NVL(:3, nvl(xxscd.INVOICE_ID, -999)) AND xxscd.STATUS = NVL(:4, xxscd.STATUS) AND TRUNC(xxscd.claim_date) between NVL(:5, to_date('01-JAN-1955', 'DD-MON-YYYY')) AND NVL(:6, TRUNC(SYSDATE)) ORDER BY xxscd.CLAIM_ID, xxscd.SUPPLIER_NAME at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java(Compiled Code))

Oracle Community | user6768197 | 4 years ago
  1. 0

    db:: 4.01::Unable to execute compiled java script from code 9j

    hivmr.com | 7 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT xxscd.CLAIM_ID, xxscd.CLAIM_NUM, xxscd.SUPPLIER_NAME, xxscd.SUPPLIER_ID, xxscd.ADDRESS, xxscd.ADDRESS_ID, xxscd.CLAIM_DATE, flvt.meaning CLAIM_TYPE, xxscd.INVOICE_NUM, xxscd.INVOICE_ID, xxscd.CLOSUER_DATE, xxscd.ORDER_NUM, flvs.meaning STATUS, xxscd.RECEIVING_CHANNEL, xxscd.LEADTIME, xxscd.EMP_ASSIGNED_NAME, xxscd.EMP_ASSIGNED_ID, xxscd.PATTERN, xxscd.SUPPLIER_TYPE, xxscd.DEPARTMENT, xxscd.ORG_ID, xxscd.CREATION_DATE, xxscd.CREATED_BY, xxscd.LAST_UPDATE_DATE, xxscd.LAST_UPDATED_BY, xxscd.LAST_UPDATE_LOGIN, xxscd.AttriBUTE1, xxscd.AttriBUTE2, xxscd.AttriBUTE3, xxscd.AttriBUTE4, xxscd.AttriBUTE5, xxscd.AttriBUTE6, xxscd.AttriBUTE7, xxscd.AttriBUTE8, xxscd.AttriBUTE9, xxscd.AttriBUTE10, xxsnt_claim_upd_enb_disab(STATUS) AS UPDATE_SWITCHER FROM XXSNT_SUPPLIER_CLAIM_DETAILS xxscd, fnd_lookup_values flvt, fnd_lookup_values flvs WHERE ((xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'Y' AND xxscd.status != 'DRAFT') OR (xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'N')) AND xxscd.CLAIM_NUM like NVL(:1, xxscd.CLAIM_NUM) AND flvt.lookup_type(+) = 'XXSNT_SUPPLIER_CLAIM_TYPE' AND flvt.lookup_code(+) = xxscd.CLAIM_TYPE AND flvt.language(+) = userenv('LANG') AND flvs.lookup_type(+) = 'XXSNT_CLAIM_STATUS' AND flvs.lookup_code(+) = xxscd.STATUS AND flvs.language(+) = userenv('LANG') AND xxscd.SUPPLIER_ID = NVL(:2, xxscd.SUPPLIER_ID) AND nvl(xxscd.INVOICE_ID, -999) = NVL(:3, nvl(xxscd.INVOICE_ID, -999)) AND xxscd.STATUS = NVL(:4, xxscd.STATUS) AND TRUNC(xxscd.claim_date) between NVL(:5, to_date('01-JAN-1955', 'DD-MON-YYYY')) AND NVL(:6, TRUNC(SYSDATE)) ORDER BY xxscd.CLAIM_ID, xxscd.SUPPLIER_NAME at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java(Compiled Code))
  2. 0

    Error message when we do search for claim in Isupplier

    Oracle Community | 4 years ago | user6768197
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT xxscd.CLAIM_ID, xxscd.CLAIM_NUM, xxscd.SUPPLIER_NAME, xxscd.SUPPLIER_ID, xxscd.ADDRESS, xxscd.ADDRESS_ID, xxscd.CLAIM_DATE, flvt.meaning CLAIM_TYPE, xxscd.INVOICE_NUM, xxscd.INVOICE_ID, xxscd.CLOSUER_DATE, xxscd.ORDER_NUM, flvs.meaning STATUS, xxscd.RECEIVING_CHANNEL, xxscd.LEADTIME, xxscd.EMP_ASSIGNED_NAME, xxscd.EMP_ASSIGNED_ID, xxscd.PATTERN, xxscd.SUPPLIER_TYPE, xxscd.DEPARTMENT, xxscd.ORG_ID, xxscd.CREATION_DATE, xxscd.CREATED_BY, xxscd.LAST_UPDATE_DATE, xxscd.LAST_UPDATED_BY, xxscd.LAST_UPDATE_LOGIN, xxscd.AttriBUTE1, xxscd.AttriBUTE2, xxscd.AttriBUTE3, xxscd.AttriBUTE4, xxscd.AttriBUTE5, xxscd.AttriBUTE6, xxscd.AttriBUTE7, xxscd.AttriBUTE8, xxscd.AttriBUTE9, xxscd.AttriBUTE10, xxsnt_claim_upd_enb_disab(STATUS) AS UPDATE_SWITCHER FROM XXSNT_SUPPLIER_CLAIM_DETAILS xxscd, fnd_lookup_values flvt, fnd_lookup_values flvs WHERE ((xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'Y' AND xxscd.status != 'DRAFT') OR (xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'N')) AND xxscd.CLAIM_NUM like NVL(:1, xxscd.CLAIM_NUM) AND flvt.lookup_type(+) = 'XXSNT_SUPPLIER_CLAIM_TYPE' AND flvt.lookup_code(+) = xxscd.CLAIM_TYPE AND flvt.language(+) = userenv('LANG') AND flvs.lookup_type(+) = 'XXSNT_CLAIM_STATUS' AND flvs.lookup_code(+) = xxscd.STATUS AND flvs.language(+) = userenv('LANG') AND xxscd.SUPPLIER_ID = NVL(:2, xxscd.SUPPLIER_ID) AND nvl(xxscd.INVOICE_ID, -999) = NVL(:3, nvl(xxscd.INVOICE_ID, -999)) AND xxscd.STATUS = NVL(:4, xxscd.STATUS) AND TRUNC(xxscd.claim_date) between NVL(:5, to_date('01-JAN-1955', 'DD-MON-YYYY')) AND NVL(:6, TRUNC(SYSDATE)) ORDER BY xxscd.CLAIM_ID, xxscd.SUPPLIER_NAME at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java(Compiled Code))
  3. 0

    Getting error in i-procurement checkout page

    Oracle Community | 2 years ago | User338888
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lookup_code, meaning from fnd_lookup_values where lookup_type = :1 and language = :2 and (lookup_code = 'EXPENSE' OR (lookup_code = 'INVENTORY' AND :3 = 'Y') OR (lookup_code = 'SHOP FLOOR' AND :4 = 'Y')) order by meaning asc
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    VO Extension giving JBO-27122 error

    Oracle Community | 2 years ago | Rvzz
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lookup_code, meaning from fnd_lookup_values where lookup_type = :1 and language = :2 and (lookup_code = 'EXPENSE' OR (lookup_code = 'INVENTORY' AND :3 = 'Y') OR (lookup_code = 'SHOP FLOOR' AND :4 = 'Y')) order by meaning asc
  6. 0

    JBO-27122: SQL error during statement preparation

    Oracle Community | 4 years ago | Bharat_Hegde
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lookup_code, meaning from fnd_lookup_values where lookup_type = :1 and language = :2 and (lookup_code = 'EXPENSE' OR (lookup_code = 'INVENTORY' AND :3 = 'Y') OR (lookup_code = 'SHOP FLOOR' AND :4 = 'Y')) order by meaning asc

    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 xxscd.CLAIM_ID, xxscd.CLAIM_NUM, xxscd.SUPPLIER_NAME, xxscd.SUPPLIER_ID, xxscd.ADDRESS, xxscd.ADDRESS_ID, xxscd.CLAIM_DATE, flvt.meaning CLAIM_TYPE, xxscd.INVOICE_NUM, xxscd.INVOICE_ID, xxscd.CLOSUER_DATE, xxscd.ORDER_NUM, flvs.meaning STATUS, xxscd.RECEIVING_CHANNEL, xxscd.LEADTIME, xxscd.EMP_ASSIGNED_NAME, xxscd.EMP_ASSIGNED_ID, xxscd.PATTERN, xxscd.SUPPLIER_TYPE, xxscd.DEPARTMENT, xxscd.ORG_ID, xxscd.CREATION_DATE, xxscd.CREATED_BY, xxscd.LAST_UPDATE_DATE, xxscd.LAST_UPDATED_BY, xxscd.LAST_UPDATE_LOGIN, xxscd.AttriBUTE1, xxscd.AttriBUTE2, xxscd.AttriBUTE3, xxscd.AttriBUTE4, xxscd.AttriBUTE5, xxscd.AttriBUTE6, xxscd.AttriBUTE7, xxscd.AttriBUTE8, xxscd.AttriBUTE9, xxscd.AttriBUTE10, xxsnt_claim_upd_enb_disab(STATUS) AS UPDATE_SWITCHER FROM XXSNT_SUPPLIER_CLAIM_DETAILS xxscd, fnd_lookup_values flvt, fnd_lookup_values flvs WHERE ((xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'Y' AND xxscd.status != 'DRAFT') OR (xxsnt_claim_status_draft(xxscd.CREATED_BY) = 'N')) AND xxscd.CLAIM_NUM like NVL(:1, xxscd.CLAIM_NUM) AND flvt.lookup_type(+) = 'XXSNT_SUPPLIER_CLAIM_TYPE' AND flvt.lookup_code(+) = xxscd.CLAIM_TYPE AND flvt.language(+) = userenv('LANG') AND flvs.lookup_type(+) = 'XXSNT_CLAIM_STATUS' AND flvs.lookup_code(+) = xxscd.STATUS AND flvs.language(+) = userenv('LANG') AND xxscd.SUPPLIER_ID = NVL(:2, xxscd.SUPPLIER_ID) AND nvl(xxscd.INVOICE_ID, -999) = NVL(:3, nvl(xxscd.INVOICE_ID, -999)) AND xxscd.STATUS = NVL(:4, xxscd.STATUS) AND TRUNC(xxscd.claim_date) between NVL(:5, to_date('01-JAN-1955', 'DD-MON-YYYY')) AND NVL(:6, TRUNC(SYSDATE)) ORDER BY xxscd.CLAIM_ID, xxscd.SUPPLIER_NAME at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Compiled Code)) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java(Compiled Code))

      at xxsnt.oracle.apps.pos.isp.webui.ClaimSearchCO.processFormRequest()
    2. xxsnt.oracle.apps
      ClaimSearchCO.processFormRequest
      1. xxsnt.oracle.apps.pos.isp.webui.ClaimSearchCO.processFormRequest(ClaimSearchCO.java:101)
      1 frame