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

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 881169, 1 year ago
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
via Oracle Community by user5425941, 1 year ago
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
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 822827, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'N' AS select_flag, mtrh.request_number, mtrl.line_number, msibkfv.concatenated_segments, mmtt.primary_quantity, mtr.reason_name reason
via Oracle Community by 541412, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: /* Formatted on 2008/05/22 13:19 (Formatter Plus v4.8.8) */ SELECT transaction_source, batch_name, expenditure_ending_date, employee_number, organization_name
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
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
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

Write tip

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