oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT acmt.CHASSIS_ID, ach.po_header_id, ACH.CHASSIS_VIN, acmt.INVOICE_RECEIPT_DATE, acmt.SUPPLIER_INVOICE, acmt.MSO_RECEIVED_DATE "MSO Received", acmt.MSO_MAILED_DATE "MSO Mailed", acmt.INVOICING_ORG_ID "Invoicing Lcation", pha.segment1, we.WIP_ENTITY_NAME Altec_Job, (SELECT hzp.party_name FROM oe_order_headers_all oe, hz_cust_accounts hca, hz_parties hzp WHERE ach.so_header_id = oe.header_id AND oe.sold_to_org_id = hca.cust_account_id AND oe.ship_to_org_id = hca.cust_account_id AND hzp.party_id = hca.party_id) Sales_Order_Bill_TO, ach.CHASSIS_MFG, acmt.mso_tracking_id FROM altec.ALTEC_CHASSIS_MSO_TRACKING acmt, altec.altec_chassis_headers ach, po_headers_all pha, wip_entities we WHERE acmt.chassis_id = ach.chassis_id AND pha.po_header_id(+) = ACH.PO_HEADER_ID AND we.WIP_ENTITY_ID(+) = ach.WIP_ENTITY_ID) QRSLT ORDER BY CHASSIS_ID ASC

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 907927, 1 year ago
Received", acmt.MSO_MAILED_DATE "MSO Mailed", acmt.INVOICING_ORG_ID "Invoicing Lcation", pha.segment1, we.WIP_ENTITY_NAME Altec_Job, (SELECT hzp.party_name FROM oe_order_headers_all oe, hz_cust_accounts hca, hz_parties hzp WHERE ach.so_header_id
via Oracle Community by 907821, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select po_header_id,line_num from po_lines_all) QRSLT WHERE (PO_HEADER_ID =:1 AND ( LINE_NUM like :2 ))
via Oracle Community by oraclepro73, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct pj.name AS PROJECT, pj.project_id, custs_assigned.party_id AS PartyId from ar_customers_assigned_v custs_assigned
via Oracle Community by 574833, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select comp_plan_id,name,org_id from cn_comp_plans_all where sysdate between start_date and nvl(end_date,sysdate+1) and org_id = :1) QRSLT WHERE (( UPPER(NAME) like :2 AND (NAME like :3 OR NAME like :4 OR NAME like :5 OR NAME like :6)))
via Oracle Community by 743539, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct pg.name grade_name, pg.grade_id, 'Yes' valid_for_job from per_valid_grades pvg, per_grades pg where pvg.grade_id = pg.grade_id
via Oracle Community by 741371, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT jrre.source_name, jrgm.group_member_id, xsts.xo2c_entering_unit entering_unit FROM jtf_rs_resource_extns jrre
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT acmt.CHASSIS_ID, ach.po_header_id, ACH.CHASSIS_VIN, acmt.INVOICE_RECEIPT_DATE, acmt.SUPPLIER_INVOICE, acmt.MSO_RECEIVED_DATE "MSO Received", acmt.MSO_MAILED_DATE "MSO Mailed", acmt.INVOICING_ORG_ID "Invoicing Lcation", pha.segment1, we.WIP_ENTITY_NAME Altec_Job, (SELECT hzp.party_name FROM oe_order_headers_all oe, hz_cust_accounts hca, hz_parties hzp WHERE ach.so_header_id = oe.header_id AND oe.sold_to_org_id = hca.cust_account_id AND oe.ship_to_org_id = hca.cust_account_id AND hzp.party_id = hca.party_id) Sales_Order_Bill_TO, ach.CHASSIS_MFG, acmt.mso_tracking_id FROM altec.ALTEC_CHASSIS_MSO_TRACKING acmt, altec.altec_chassis_headers ach, po_headers_all pha, wip_entities we WHERE acmt.chassis_id = ach.chassis_id AND pha.po_header_id(+) = ACH.PO_HEADER_ID AND we.WIP_ENTITY_ID(+) = ach.WIP_ENTITY_ID) QRSLT ORDER BY CHASSIS_ID ASC
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2381)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1609)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 6 days 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, 1 year 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.