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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    hivmr.com | 12 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))

    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