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 Oracle Community by 1010599, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hp.party_name, hp.party_id as party_id, hp.duns_number_c as duns, pv.vendor_id, pv.vendor_name, decode(pv.organization_type_lookup_code
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 807913, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Vac.VACANCY_ID, Vac.DATE_FROM, Vac.NAME, Vac.DATE_TO, Vac.DESCRIPTION, Vac.NUMBER_OF_OPENINGS, Vac.LAST_UPDATE_DATE, Vac.CREATION_DATE, Job.NAME AS
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 user621385, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT paf1.full_name, paf1.last_name, paf1.first_name, paf1.email_address, nvl(paf1.employee_number,paf1.npw_number) AS employee_num
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hp.party_name,
hp.party_id as party_id,
hp.duns_number_c as duns,
pv.vendor_id,
pv.vendor_name,
decode(pv.organization_type_lookup_code,
'INDIVIDUAL',pv.individual_1099,
'FOREIGN INDIVIDUAL',pv.individual_1099, pv.num_1099) taxpayer_id,
pv.vat_registration_num as tax_reg_num,
pv.segment1,
pv.VENDOR_NAME_ALT as alternate_name,
pv.end_date_active as end_date_active,
pv.start_date_active as start_date_active,
pv.ONE_TIME_FLAG,
pv.VENDOR_TYPE_LOOKUP_CODE,
pv.PARENT_VENDOR_ID,
parent.vendor_name as parent_vendor_name,
pv.PAYMENT_PRIORITY,
parent.segment1 as parent_Segment1,
pv.TAX_REPORTING_NAME,
pv.terms_id,
terms.name as terms_desc,
pv.FEDERAL_REPORTABLE_FLAG,
pv.STATE_REPORTABLE_FLAG,
pv.PAY_GROUP_LOOKUP_CODE,
pay_group.description as pay_group_desc,
aptt.description as income_tax_type,
hp.organization_name_phonetic,
plc.DISPLAYED_FIELD as VENDOR_TYPE_DISPLAY,
pv.type_1099 as income_tax_type_code,
pv.employee_id as employee_id,
pecx.employee_num AS employee_number
from hz_parties hp,
ap_suppliers pv,
ap_suppliers parent,
ap_terms_tl terms,
fnd_lookup_values pay_group,
AP_INCOME_TAX_TYPES aptt,
po_lookup_codes plc,
per_employees_current_x pecx
where pv.party_id = hp.party_id AND
pv.party_id = pecx.party_id (+) and
parent.vendor_id (+) = pv.parent_vendor_id and
pv.terms_id = terms.term_id (+)
and terms.language (+) = userenv('LANG') and
terms.enabled_flag (+) ='Y' and
pv.pay_group_lookup_code = pay_group.lookup_code (+) and
pay_group.lookup_type (+)='PAY GROUP' and
pay_group.language (+)=userenv('lang') and
pv.type_1099 = aptt.income_tax_type (+) and
pv.VENDOR_TYPE_LOOKUP_CODE = plc.LOOKUP_CODE (+) and
plc.lookup_type (+) = 'VENDOR TYPE') QRSLT WHERE (PAY_GROUP_LOOKUP_CODE like '> 2 MILLION%') ORDER BY VENDOR_NAME 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:2972)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1852)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)