oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT msix.item_name, msix.description, msix.organization_id, msix.primary_uom_code, msix.inventory_item_id, msix.category_name, msix.category_description, msix.category_id, msix.list_price, msix.inv_direct_item_type, msix.item_cost, msix.cross_reference_type, msix.cross_reference, msix.description2, mfnum.manufacturer_name, mfnum.mfg_part_num, (SELECT NVL((SELECT 'Item is on Blanket' FROM po.po_approved_supplier_list psl WHERE psl.item_id=msix.inventory_item_id AND psl.using_organization_id=msix.organization_id AND EXISTS (SELECT 1 FROM po.po_asl_documents psd, po.po_headers_all pha, po.po_lines_all pla WHERE psd.asl_id=psl.asl_id AND psd.document_type_code='BLANKET' AND pha.po_header_id=psd.document_header_id AND pha.authorization_status = 'APPROVED' AND NVL(pha.closed_code, 'OPEN') = 'OPEN' AND pla.po_line_id=psd.document_line_id AND pla.item_id=psl.item_id AND NVL(pla.closed_code, 'OPEN') = 'OPEN') AND rownum=1),'Not on Blanket')FROM dual) Blanket FROM ( SELECT msik.concatenated_segments AS item_name, msik.description, msik.organization_id, msik.primary_uom_code, msik.inventory_item_id, mcg.category_name, mcg.category_description, mcg.category_id, msik.list_price_per_unit AS list_price, DECODE(stock_enabled_flag, 'N', 2, 1) AS inv_direct_item_type, (SELECT NVL(ccicv.item_cost, 0) FROM mtl_parameters mp, cst_cg_item_costs_view ccicv WHERE ccicv.organization_id = mp.organization_id AND ccicv.organization_id = msik.organization_id AND ccicv.inventory_item_id = msik.inventory_item_id AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, -1)) AND rownum <= 1) AS item_cost, xref.cross_reference, xref.cross_reference_type, xref.description as description2 FROM mtl_system_items_vl msik LEFT OUTER JOIN (SELECT mc.concatenated_segments AS category_name, mc.description AS category_description, mc.category_id, mic.inventory_item_id, mic.organization_id FROM mtl_item_categories mic, mtl_categories_kfv mc, mtl_category_sets mcs, mtl_default_category_sets mdcs WHERE mcs.category_set_id = mdcs.category_set_id AND mdcs.functional_area_id = 2 AND mcs.structure_id = mc.structure_id AND mic.category_set_id = mdcs.category_set_id AND mc.category_id = mic.category_id ) mcg ON (mcg.organization_id = msik.organization_id AND mcg.inventory_item_id = msik.inventory_item_id) LEFT OUTER JOIN mtl_cross_references xref ON (xref.inventory_item_id = msik.inventory_item_id) WHERE msik.bom_item_type = 4 AND(msik.eam_item_type IS NULL OR msik.eam_item_type IN(1, 3)) AND((stock_enabled_flag = 'N' AND msik.purchasing_item_flag = 'Y' AND msik.purchasing_enabled_flag = 'Y') OR(stock_enabled_flag = 'Y')) AND (xref.organization_id = msik.organization_id OR xref.organization_id IS NULL) ) msix LEFT OUTER JOIN (SELECT mcr.cross_reference as cref, mcr.description as desc1, msi.inventory_item_id as inv1, msi.organization_id as org1, mpn.mfg_part_num, mfg.manufacturer_name FROM MTL_MFG_PART_NUMBERS MPN, MTL_MANUFACTURERS MFG, mtl_parameters mp, mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES mcr ON (mcr.inventory_item_id = msi.inventory_item_id) WHERE (mcr.description = (SELECT xref.description FROM mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id) WHERE msi.inventory_item_id = mcr.inventory_item_id AND ROWNUM <=1 ) OR mcr.description IS NULL) AND (mcr.organization_id = (SELECT xref.organization_id FROM mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id) WHERE msi.inventory_item_id = mcr.inventory_item_id AND ROWNUM <=1 ) or (mcr.organization_id is NULL)) AND (mcr.cross_reference = (SELECT cross_reference FROM mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id) WHERE msi.inventory_item_id = mcr.inventory_item_id AND ROWNUM <=1 ) OR mcr.description IS NULL) AND MPN.MANUFACTURER_ID = MFG.MANUFACTURER_ID AND mpn.organization_id = mp.master_organization_id AND msi.inventory_item_id = mpn.inventory_item_id AND mp.organization_id = msi.organization_id) mfnum ON (((mfnum.cref = msix.cross_reference) OR (mfnum.cref IS NULL AND msix.cross_reference IS NULL)) AND ((mfnum.desc1 = msix.description2) OR (mfnum.cref IS NULL AND msix.cross_reference IS NULL)) AND mfnum.inv1 = msix.inventory_item_id AND mfnum.org1 = msix.organization_id)) QRSLT WHERE (organization_id = :1 and inv_direct_item_type = :2 AND ( UPPER(ITEM_NAME) like UPPER(:3) AND (ITEM_NAME like :4 OR ITEM_NAME like :5 OR ITEM_NAME like :6 OR ITEM_NAME like :7)))

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 Harrrry, 1 year ago
po.po_approved_supplier_list psl WHERE psl.item_id=msix.inventory_item_id AND psl.using_organization_id=msix.organization_id AND EXISTS (SELECT 1 FROM po.po_asl_documents psd, po.po_headers_all pha, po.po_lines_all pla WHERE psd.asl_id=psl.asl_id
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 Dharma_, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprvl.PAYMENT_REASON_CODE, ibyprvl.MEANING, ibyprvl.DESCRIPTION, ibyprvl.territory_code, countries.territory_short_name FROM IBY_PAYMENT_REASONS_VL
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 Bipin Behari Sethy, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE
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
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT msix.item_name, msix.description, msix.organization_id, msix.primary_uom_code, msix.inventory_item_id, msix.category_name, msix.category_description, msix.category_id, msix.list_price, msix.inv_direct_item_type, msix.item_cost, msix.cross_reference_type, msix.cross_reference, msix.description2, mfnum.manufacturer_name, mfnum.mfg_part_num, (SELECT NVL((SELECT 'Item is on Blanket' FROM po.po_approved_supplier_list psl WHERE psl.item_id=msix.inventory_item_id AND psl.using_organization_id=msix.organization_id AND EXISTS (SELECT 1 FROM po.po_asl_documents psd, po.po_headers_all pha, po.po_lines_all pla WHERE psd.asl_id=psl.asl_id AND psd.document_type_code='BLANKET' AND pha.po_header_id=psd.document_header_id AND pha.authorization_status = 'APPROVED' AND NVL(pha.closed_code, 'OPEN') = 'OPEN' AND pla.po_line_id=psd.document_line_id AND pla.item_id=psl.item_id AND NVL(pla.closed_code, 'OPEN') = 'OPEN') AND rownum=1),'Not on Blanket')FROM dual) Blanket FROM ( SELECT msik.concatenated_segments AS item_name, msik.description, msik.organization_id, msik.primary_uom_code, msik.inventory_item_id, mcg.category_name, mcg.category_description, mcg.category_id, msik.list_price_per_unit AS list_price, DECODE(stock_enabled_flag, 'N', 2, 1) AS inv_direct_item_type, (SELECT NVL(ccicv.item_cost, 0) FROM mtl_parameters mp, cst_cg_item_costs_view ccicv WHERE ccicv.organization_id = mp.organization_id AND ccicv.organization_id = msik.organization_id AND ccicv.inventory_item_id = msik.inventory_item_id AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, -1)) AND rownum <= 1) AS item_cost, xref.cross_reference, xref.cross_reference_type, xref.description as description2 FROM mtl_system_items_vl msik LEFT OUTER JOIN (SELECT mc.concatenated_segments AS category_name, mc.description AS category_description, mc.category_id, mic.inventory_item_id, mic.organization_id FROM mtl_item_categories mic, mtl_categories_kfv mc, mtl_category_sets mcs, mtl_default_category_sets mdcs WHERE mcs.category_set_id = mdcs.category_set_id AND mdcs.functional_area_id = 2 AND mcs.structure_id = mc.structure_id AND mic.category_set_id = mdcs.category_set_id AND mc.category_id = mic.category_id ) mcg ON (mcg.organization_id = msik.organization_id AND mcg.inventory_item_id = msik.inventory_item_id) LEFT OUTER JOIN mtl_cross_references xref ON (xref.inventory_item_id = msik.inventory_item_id) WHERE msik.bom_item_type = 4 AND(msik.eam_item_type IS NULL OR msik.eam_item_type IN(1, 3)) AND((stock_enabled_flag = 'N' AND msik.purchasing_item_flag = 'Y' AND msik.purchasing_enabled_flag = 'Y') OR(stock_enabled_flag = 'Y')) AND (xref.organization_id = msik.organization_id OR xref.organization_id IS NULL) ) msix LEFT OUTER JOIN (SELECT mcr.cross_reference as cref, mcr.description as desc1, msi.inventory_item_id as inv1, msi.organization_id as org1, mpn.mfg_part_num, mfg.manufacturer_name FROM MTL_MFG_PART_NUMBERS MPN, MTL_MANUFACTURERS MFG, mtl_parameters mp, mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES mcr ON (mcr.inventory_item_id = msi.inventory_item_id) WHERE (mcr.description = (SELECT xref.description FROM mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id) WHERE msi.inventory_item_id = mcr.inventory_item_id AND ROWNUM <=1 ) OR mcr.description IS NULL) AND (mcr.organization_id = (SELECT xref.organization_id FROM mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id) WHERE msi.inventory_item_id = mcr.inventory_item_id AND ROWNUM <=1 ) or (mcr.organization_id is NULL)) AND (mcr.cross_reference = (SELECT cross_reference FROM mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id) WHERE msi.inventory_item_id = mcr.inventory_item_id AND ROWNUM <=1 ) OR mcr.description IS NULL) AND MPN.MANUFACTURER_ID = MFG.MANUFACTURER_ID AND mpn.organization_id = mp.master_organization_id AND msi.inventory_item_id = mpn.inventory_item_id AND mp.organization_id = msi.organization_id) mfnum ON (((mfnum.cref = msix.cross_reference) OR (mfnum.cref IS NULL AND msix.cross_reference IS NULL)) AND ((mfnum.desc1 = msix.description2) OR (mfnum.cref IS NULL AND msix.cross_reference IS NULL)) AND mfnum.inv1 = msix.inventory_item_id AND mfnum.org1 = msix.organization_id)) QRSLT WHERE (organization_id = :1 and inv_direct_item_type = :2 AND ( UPPER(ITEM_NAME) like UPPER(:3) AND (ITEM_NAME like :4 OR ITEM_NAME like :5 OR ITEM_NAME like :6 OR ITEM_NAME like :7)))
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:2972)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1852)
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, 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.