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 Dharma_, 1 year ago
ibyprvl, fnd_territories_vl countries WHERE countries.territory_code(+)=ibyprvl.territory_code AND sysdate >= NVL(ibyprvl.INACTIVE_DATE,sysdate) /*and ((ibyprvl.territory_code is NULL) or (ibyprvl.territory_code in ( select hl.country from
via Oracle Community by 662449, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT hcs.site_use_id, hcs.primary_flag, hcac.ACCOUNT_NUMBER FROM hz_locations hlo, hz_party_sites hps, hz_cust_acct_sites_all hca
via Oracle Community by 814480, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pc.competence_id ,pc.name ,pc.competence_alias as short_name ,pc.unit_standard_id ,qual_ctype.meaning credit_type ,pc.credits ,qual_level_type.meaning
via Oracle Community by 882688, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID
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 877023, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT score (1) AS score, doc.document_id, doc.file_name, doc.last_update_date, ppf.email_address, addr.derived_locale, addr.address_id, ppf.full_name
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprvl.PAYMENT_REASON_CODE,
ibyprvl.MEANING,
ibyprvl.DESCRIPTION,
ibyprvl.territory_code,
countries.territory_short_name
FROM IBY_PAYMENT_REASONS_VL ibyprvl,
fnd_territories_vl countries
WHERE countries.territory_code(+)=ibyprvl.territory_code
AND sysdate >= NVL(ibyprvl.INACTIVE_DATE,sysdate)
/*and
((ibyprvl.territory_code is NULL) or
(ibyprvl.territory_code in
( select hl.country from ap_supplier_sites_all assa, hz_party_sites hps, hz_locations hl
where assa.vendor_site_id = :1
and assa.party_site_id = hps.party_site_id
and hps.location_id = hl.location_id)))*/	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)