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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web1201

  • via hivmr.com by Unknown author, 1 year ago
    , -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
  • via Oracle Community by user6768197, 11 months ago
    , -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
  • via Oracle Community by 492297, 2 weeks ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = :1 AND VIEW_APPLICATION_ID = :2 AND LANGUAGE = USERENV('LANG') AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)
  • Stack trace

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

    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

    You’re the first here who have seen this exception.