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 884536, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num, msi.segment1 item_num, pol.vendor_product_num, pol.item_description
via Oracle Community by 884536, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num, msi.segment1 item_num, pol.vendor_product_num, pol.item_description
via Oracle Community by 748660, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. . .
via Oracle Community by 795088, 1 year ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.IllegalAccessError, msg=oracle/jdbc/driver/OracleCallableStatement
via Oracle Community by nv Teja, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT cesEO.EMPNO, cesEO.ENAME, cesEO.JOB, cesEO.MGR, cesEO.HIREDATE, cesEO.SAL, cesEO.COMM, cesEO.DEPTNO FROM EMP1 cesEO
via blogspot.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT cesEO.EMPNO, cesEO.ENAME, cesEO.JOB, cesEO.MGR, cesEO.HIREDATE, cesEO.SAL, cesEO.COMM, cesEO.DEPTNO FROM EMP1 cesEO
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num,
msi.segment1 item_num, pol.vendor_product_num,
pol.item_description, pol.unit_meas_lookup_code,
pol.quantity, pol.unit_price,
pol.quantity * pol.unit_price total, poh.segment1 po_num,
poh.currency_code, pol.item_id,
fsp.inventory_organization_id,
msi.segment1 segment1, pol.from_header_id,
pola.closed_code, pola.cancel_flag, pola.closed_flag,
pola.user_hold_flag, pol.attribute1, pol.attribute2,
pol.attribute3, pol.attribute4, pol.attribute5,
pol.attribute6, pol.attribute7, pol.attribute8,
pol.attribute9, pol.attribute10, pol.attribute11,
pol.attribute12, pol.attribute13, pol.attribute14,
pol.attribute15, pol.attribute_category, pol.note_to_vendor,
poh2.segment1 contract_num,
pol.item_revision,
pol.ussgl_transaction_code, NULL un_number,
NULL hazard_class, pol.quantity_committed,
pol.committed_amount, pol.expiration_date,
NVL (pocr.new_price, pol.unit_price) new_price,
NVL (pocr.new_supplier_part_number,
pol.vendor_product_num
) new_supplier_part_number,
pocr.request_status, 0 viewshipments, 'SItemType',
'PriceType', 'LineStatus',
NVL
(pos_get.get_item_config (pol.item_id,
fsp.inventory_organization_id
),
'F'
) conf_flag,
NULL ga_number, pocr.request_reason,
DECODE
(pocr.request_status,
NULL, polc.displayed_field,
fnd_message.get_string ('POS', 'POS_PENDING_CHANGE')
) line_display,
pol.hazard_class_id, pol.un_number_id, NULL conf_details,
'REASON_TYPE', pol.job_id, pol.contractor_first_name,
pol.contractor_last_name, 'LINE_PRICE_DIFF_TYPE',
polt.order_type_lookup_code line_type,
pj.NAME job_title,
poh.global_agreement_flag, poh.type_lookup_code,
'ENTITY_TYPE', polt.line_type line_type_dsp,
pa.job_description,
NULL contractor_name,
pol.amount line_amount, pol.supplier_ref_number,
DECODE
(pol.po_line_id, pol.line_num),
0, NULL,
'@'
) archived_attachment
FROM po_lines_archive_all pol,
po_lines_all pola,
po_headers_all poh,
mtl_system_items_kfv msi,
financials_system_params_all fsp,
po_lookup_codes polc,
po_change_requests pocr,
po_line_types polt,
per_jobs pj,
po_job_associations pa,
po_headers_all poh2
WHERE poh.po_header_id = pol.po_header_id
AND poh.po_header_id = pola.po_header_id
AND poh.po_header_id = poh.po_header_id + 0
AND pol.contract_id = poh2.po_header_id(+)
AND pol.latest_external_flag = 'Y'
AND pol.po_line_id = pola.po_line_id
AND pol.line_type_id = polt.line_type_id
AND pol.job_id = pj.job_id(+)
AND pol.job_id = pa.job_id(+)
AND pol.item_id = msi.inventory_item_id(+)
AND fsp.inventory_organization_id =
NVL (msi.organization_id, fsp.inventory_organization_id)
AND fsp.org_id(+) = poh.org_id
AND polc.lookup_code = NVL (pola.closed_code, 'OPEN')
AND polc.lookup_type = 'DOCUMENT STATE'
AND pol.po_header_id = pocr.document_header_id(+)
AND pol.po_line_id = pocr.document_line_id(+)
AND pocr.request_level(+) = 'LINE'
AND pocr.change_active_flag(+) = 'Y') QRSLT WHERE (PO_HEADER_ID = :1) ORDER BY LINE_NUM	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)	at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)	at oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1136)	at oracle.apps.pos.changeorder.webui.PosViewPOCO.processRequest(PosViewPOCO.java:298)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)