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)))*/

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)

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, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 more bugmates

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