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 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 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 Asmirnov-Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99
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
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 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 /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */
OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID
, OTA_RESOURCE_DEFINITIONS.SEGMENT1 FLEX_DISPLAY0
, FLEX_T1_0.MEANING FLEX_DISPLAY1
, fnd_flex_server.get_concatenated_value(
, :SEGMENT_COUNT
, OTA_RESOURCE_DEFINITIONS.SEGMENT1
, FLEX_T1_0.MEANING
) FLEX_CONCATENATED_DISPLAY
FROM OTA_RESOURCE_DEFINITIONS
, FND_COMMON_LOOKUPS FLEX_T1_0
WHERE (OTA_RESOURCE_DEFINITIONS.enabled_flag = 'Y'
and nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))
between nvl(trunc(OTA_RESOURCE_DEFINITIONS.start_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate)))
and nvl(trunc(OTA_RESOURCE_DEFINITIONS.end_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate)))
and OTA_RESOURCE_DEFINITIONS.ID_FLEX_NUM = :STRUCTURE
and 1 = 1
and 1 = 1
and OTA_RESOURCE_DEFINITIONS.SEGMENT2 = FLEX_T1_0.LOOKUP_CODE
and ( LOOKUP_TYPE='MOSTAFA_TRAINER_CLASSIFICATION'
AND ENABLED_FLAG = 'Y')
and OTA_RESOURCE_DEFINITIONS.SEGMENT1 like :FLEX_QUERY_VALUE0
and FLEX_T1_0.MEANING like :FLEX_QUERY_VALUE1) ORDER BY FLEX_DISPLAY0
, FLEX_DISPLAY1	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)