oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PoVendors.VENDOR_ID AS SUPPLIER_ID, PoVendorSitesAll.VENDOR_SITE_ID AS SUPPLIER_SITE_ID, PoVendorContacts.VENDOR_CONTACT_ID AS SUPPLIER_CONTACT_ID, PoVendors.VENDOR_NAME AS SUPPLIER_NAME, DECODE(PoVendorContacts.FIRST_NAME, NULL, PoVendorContacts.LAST_NAME, PoVendorContacts.LAST_NAME||', '||PoVendorContacts.FIRST_NAME) AS SUPPLIER_CONTACT_NAME, PoVendorSitesAll.ADDRESS_LINE1 || ' ' || PoVendorSitesAll.ADDRESS_LINE2 || ' ' PoVendorSitesAll.ADDRESS_LINE3 ' ' PoVendorSitesAll.CITY ' ' PoVendorSitesAll.STATE || ' ' ||PoVendorSitesAll.ZIP || ' ' || PoVendorSitesAll.COUNTRY AS ADDRESS, DECODE(TRUNC(LENGTH(PoVendorContacts.AREA_CODE||' '||PoVendorContacts.PHONE)/26),0, PoVendorContacts.AREA_CODE || DECODE(PoVendorContacts.AREA_CODE,null,null,DECODE(PoVendorContacts.PHONE,null,null,' '))||PoVendorContacts.PHONE, PoVendorContacts.AREA_CODE||PoVendorContacts.PHONE) AS PHONE, PoVendorContacts.EMAIL_ADDRESS AS EMAIL_ADDRESS, DECODE(TRUNC(LENGTH(PoVendorContacts.FAX_AREA_CODE||' '||PoVendorContacts.FAX)/26),0, PoVendorContacts.FAX_AREA_CODE || DECODE(PoVendorContacts.FAX_AREA_CODE,null,null,DECODE(PoVendorContacts.FAX,null,null,' '))||PoVendorContacts.FAX, PoVendorContacts.FAX_AREA_CODE||PoVendorContacts.FAX) AS FAX, PoVendorSitesAll.VENDOR_SITE_CODE AS SUPPLIER_SITE, PoVendors.segment1 AS SUPPLIER_NUMBER FROM PO_VENDORS PoVendors, PO_VENDOR_CONTACTS PoVendorContacts, PO_VENDOR_SITES_ALL PoVendorSitesAll WHERE NVL(PoVendors.ENABLED_FLAG,'Y') = 'Y' AND PoVendors.VENDOR_ID = PoVendorSitesAll.VENDOR_ID(+) AND (PoVendors.VENDOR_TYPE_LOOKUP_CODE is null OR PoVendors.VENDOR_TYPE_LOOKUP_CODE 'EMPLOYEE') AND TRUNC(SYSDATE) BETWEEN NVL(PoVendors.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(PoVendors.END_DATE_ACTIVE, TRUNC(SYSDATE)) AND decode(PoVendorSitesAll.PURCHASING_SITE_FLAG(+), 'Y', 'Y', PoVendorSitesAll.RFQ_ONLY_SITE_FLAG(+)) = 'Y' AND nvl(PoVendorSitesAll.ORG_ID(+), :1) = :2 AND TRUNC(SYSDATE) < NVL(PoVendorSitesAll.INACTIVE_DATE(+), TRUNC(SYSDATE + 1)) AND PoVendorSitesAll.VENDOR_SITE_ID = PoVendorContacts.VENDOR_SITE_ID(+) AND TRUNC(SYSDATE) < NVL(PoVendorContacts.INACTIVE_DATE(+), TRUNC(SYSDATE + 1))) QRSLT WHERE (( UPPER(SUPPLIER_NAME) like UPPER( :2) )) ORDER BY SUPPLIER_NAME ASC, SUPPLIER_SITE ASC

Samebug tips0

There are no available Samebug tips.

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

Stack trace

  • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PoVendors.VENDOR_ID AS SUPPLIER_ID, PoVendorSitesAll.VENDOR_SITE_ID AS SUPPLIER_SITE_ID, PoVendorContacts.VENDOR_CONTACT_ID AS SUPPLIER_CONTACT_ID, PoVendors.VENDOR_NAME AS SUPPLIER_NAME, DECODE(PoVendorContacts.FIRST_NAME, NULL, PoVendorContacts.LAST_NAME, PoVendorContacts.LAST_NAME||', '||PoVendorContacts.FIRST_NAME) AS SUPPLIER_CONTACT_NAME, PoVendorSitesAll.ADDRESS_LINE1 || ' ' || PoVendorSitesAll.ADDRESS_LINE2 || ' ' PoVendorSitesAll.ADDRESS_LINE3 ' ' PoVendorSitesAll.CITY ' ' PoVendorSitesAll.STATE || ' ' ||PoVendorSitesAll.ZIP || ' ' || PoVendorSitesAll.COUNTRY AS ADDRESS, DECODE(TRUNC(LENGTH(PoVendorContacts.AREA_CODE||' '||PoVendorContacts.PHONE)/26),0, PoVendorContacts.AREA_CODE || DECODE(PoVendorContacts.AREA_CODE,null,null,DECODE(PoVendorContacts.PHONE,null,null,' '))||PoVendorContacts.PHONE, PoVendorContacts.AREA_CODE||PoVendorContacts.PHONE) AS PHONE, PoVendorContacts.EMAIL_ADDRESS AS EMAIL_ADDRESS, DECODE(TRUNC(LENGTH(PoVendorContacts.FAX_AREA_CODE||' '||PoVendorContacts.FAX)/26),0, PoVendorContacts.FAX_AREA_CODE || DECODE(PoVendorContacts.FAX_AREA_CODE,null,null,DECODE(PoVendorContacts.FAX,null,null,' '))||PoVendorContacts.FAX, PoVendorContacts.FAX_AREA_CODE||PoVendorContacts.FAX) AS FAX, PoVendorSitesAll.VENDOR_SITE_CODE AS SUPPLIER_SITE, PoVendors.segment1 AS SUPPLIER_NUMBER FROM PO_VENDORS PoVendors, PO_VENDOR_CONTACTS PoVendorContacts, PO_VENDOR_SITES_ALL PoVendorSitesAll WHERE NVL(PoVendors.ENABLED_FLAG,'Y') = 'Y' AND PoVendors.VENDOR_ID = PoVendorSitesAll.VENDOR_ID(+) AND (PoVendors.VENDOR_TYPE_LOOKUP_CODE is null OR PoVendors.VENDOR_TYPE_LOOKUP_CODE 'EMPLOYEE') AND TRUNC(SYSDATE) BETWEEN NVL(PoVendors.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(PoVendors.END_DATE_ACTIVE, TRUNC(SYSDATE)) AND decode(PoVendorSitesAll.PURCHASING_SITE_FLAG(+), 'Y', 'Y', PoVendorSitesAll.RFQ_ONLY_SITE_FLAG(+)) = 'Y' AND nvl(PoVendorSitesAll.ORG_ID(+), :1) = :2 AND TRUNC(SYSDATE) < NVL(PoVendorSitesAll.INACTIVE_DATE(+), TRUNC(SYSDATE + 1)) AND PoVendorSitesAll.VENDOR_SITE_ID = PoVendorContacts.VENDOR_SITE_ID(+) AND TRUNC(SYSDATE) < NVL(PoVendorContacts.INACTIVE_DATE(+), TRUNC(SYSDATE + 1))) QRSLT WHERE (( UPPER(SUPPLIER_NAME) like UPPER( :2) )) ORDER BY SUPPLIER_NAME ASC, SUPPLIER_SITE ASC at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

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

Unknown visitor
Unknown visitor1 times, last one,
Unknown visitor
Unknown visitor1 times, last one,
Unknown visitor
Unknown visitor1 times, last one,
Unknown visitor
Unknown visitor1 times, last one,
Unknown visitor
Unknown visitor1 times, last one,
14 more bugmates