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

Oracle Community | 882688 | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error when i create a resourse

    Oracle Community | 5 years ago | 882688
    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
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    how to get a value standad page to custom page

    Oracle Community | 6 years ago | 725826
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. 0

    Migration issue in OAF-urgent

    Oracle Community | 6 years ago | user5425941
    oracle.apps.fnd.framework.OAException: 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) as amount, poh.ACCEPTANCE_DUE_DATE, poh.vendor_id, poh.po_header_id, poh.agent_id, poh.type_lookup_code, poh.type_name, poh.vendor_contact_id, poh.vendor_site_id, poh.acceptance_required_flag, poh.approved_date, poh.revision_num, to_char(null) PO_STATUS_CODE , to_char(null) PO_STATUS_DISP , poh.org_name, poh.attribute1, poh.attribute2, poh.attribute3, poh.attribute4, poh.attribute5, poh.attribute6, poh.attribute7, poh.attribute8, poh.attribute9, poh.attribute10, poh.attribute11, poh.attribute12, poh.attribute13, poh.attribute14, poh.attribute15, poh.attribute_category, decode(poh.po_release_id,null,'PosHdrAttach','PosRelAttach') as SwitchAttach, 'N' as retrieve_flag, poh.CANCEL_FLAG, poh.CLOSED_CODE, poh.FROZEN_FLAG, poh.USER_HOLD_FLAG, poh.global_agreement_flag, to_char(null) consigned_consumption_flag, poh.vendor_name, poh.vendor_site_code, poh.po_release_id po_release_id2, poh.vendor_number , poh.vendor_id vendor_id2, org_id, poh.segment1, poh.release_num, to_char(null) business_document_type, to_char(null) business_document_id, to_char(null) business_document_version, 0 as ship_to_location_id, security_level_code, access_level_code from spos_view_po_summary_v poh) QRSLT WHERE (VENDOR_ID in (:1) AND VENDOR_CONTACT_ID in (:2) AND ((VENDOR_SITE_ID in (:3) AND NVL(global_agreement_flag, 'N') = 'N') OR (PO_RELEASE_ID is null AND PO_HEADER_ID in ( select PGA.po_header_id from PO_GA_ORG_ASSIGNMENTS PGA, PO_HEADERS_ALL POH where PGA.po_header_id = POH.po_header_id and PGA.enabled_flag = 'Y' and POH.global_agreement_flag = 'Y' and PGA.vendor_site_id in (:4))))) ORDER BY APPROVED_DATE DESC

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      7 frames