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

Oracle Community | user10648285 | 4 years ago
  1. 0

    R12 issue: oracle.jbo.SQLStmtException: JBO-27122: SQL error

    Oracle Community | 4 years ago | user10648285
    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
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    how to get a value standad page to custom page

    Oracle Community | 6 years ago | 725826
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. 0

    Migration issue in OAF-urgent

    Oracle Community | 5 years ago | user5425941
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0) as amount, poh.ACCEPTANCE_DUE_DATE, poh.vendor_id, poh.po_header_id, poh.agent_id, poh.type_lookup_code, poh.type_name, poh.vendor_contact_id, poh.vendor_site_id, poh.acceptance_required_flag, poh.approved_date, poh.revision_num, to_char(null) PO_STATUS_CODE , to_char(null) PO_STATUS_DISP , poh.org_name, poh.attribute1, poh.attribute2, poh.attribute3, poh.attribute4, poh.attribute5, poh.attribute6, poh.attribute7, poh.attribute8, poh.attribute9, poh.attribute10, poh.attribute11, poh.attribute12, poh.attribute13, poh.attribute14, poh.attribute15, poh.attribute_category, decode(poh.po_release_id,null,'PosHdrAttach','PosRelAttach') as SwitchAttach, 'N' as retrieve_flag, poh.CANCEL_FLAG, poh.CLOSED_CODE, poh.FROZEN_FLAG, poh.USER_HOLD_FLAG, poh.global_agreement_flag, to_char(null) consigned_consumption_flag, poh.vendor_name, poh.vendor_site_code, poh.po_release_id po_release_id2, poh.vendor_number , poh.vendor_id vendor_id2, org_id, poh.segment1, poh.release_num, to_char(null) business_document_type, to_char(null) business_document_id, to_char(null) business_document_version, 0 as ship_to_location_id, security_level_code, access_level_code from spos_view_po_summary_v poh) QRSLT WHERE (VENDOR_ID in (:1) AND VENDOR_CONTACT_ID in (:2) AND ((VENDOR_SITE_ID in (:3) AND NVL(global_agreement_flag, 'N') = 'N') OR (PO_RELEASE_ID is null AND PO_HEADER_ID in ( select PGA.po_header_id from PO_GA_ORG_ASSIGNMENTS PGA, PO_HEADERS_ALL POH where PGA.po_header_id = POH.po_header_id and PGA.enabled_flag = 'Y' and POH.global_agreement_flag = 'Y' and PGA.vendor_site_id in (:4))))) ORDER BY APPROVED_DATE DESC

    11 unregistered visitors
    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 * 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      7 frames