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

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by user10648285, 1 year ago
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
via Oracle Community by Renu Gupta, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID
via Oracle Community by 667099, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select msi.secondary_inventory_name as SubInventoryName, msi.description as Description, msi.locator_type, msi.organization_id
via Oracle Community by 584085, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT feb.entity_id, rel.parent_entity_id, fetl.entity_name, pfetl.entity_name parent_entity_name, ccytl.currency_code, ccytl.name AS
via Oracle Community by user5425941, 1 year ago
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
via Oracle Community by 881169, 1 year ago
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
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

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