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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via hivmr.com by Unknown author, 1 year ago
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
via Oracle Community by user6768197, 1 year ago
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
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(ClaimSearchCO.java:101)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.