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)))

Oracle Community | Harrrry | 6 years ago
  1. 0

    Geting error at VO extension:JBO-27122: SQL error during statement preparat

    Oracle Community | 6 years ago | Harrrry
    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)))
  2. 0

    Null pointer exception while&nbsp; extending OrderCO

    Oracle Community | 7 years ago | 561631
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  3. 0

    Clear button Issue

    Oracle Community | 6 years ago | 833116
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error in CO Extension: oracle.jbo.SQLStmtException: JBO-27122: SQL error du

    Oracle Community | 4 years ago | 1010599
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hp.party_name, hp.party_id as party_id, hp.duns_number_c as duns, pv.vendor_id, pv.vendor_name, decode(pv.organization_type_lookup_code, 'INDIVIDUAL',pv.individual_1099, 'FOREIGN INDIVIDUAL',pv.individual_1099, pv.num_1099) taxpayer_id, pv.vat_registration_num as tax_reg_num, pv.segment1, pv.VENDOR_NAME_ALT as alternate_name, pv.end_date_active as end_date_active, pv.start_date_active as start_date_active, pv.ONE_TIME_FLAG, pv.VENDOR_TYPE_LOOKUP_CODE, pv.PARENT_VENDOR_ID, parent.vendor_name as parent_vendor_name, pv.PAYMENT_PRIORITY, parent.segment1 as parent_Segment1, pv.TAX_REPORTING_NAME, pv.terms_id, terms.name as terms_desc, pv.FEDERAL_REPORTABLE_FLAG, pv.STATE_REPORTABLE_FLAG, pv.PAY_GROUP_LOOKUP_CODE, pay_group.description as pay_group_desc, aptt.description as income_tax_type, hp.organization_name_phonetic, plc.DISPLAYED_FIELD as VENDOR_TYPE_DISPLAY, pv.type_1099 as income_tax_type_code, pv.employee_id as employee_id, pecx.employee_num AS employee_number from hz_parties hp, ap_suppliers pv, ap_suppliers parent, ap_terms_tl terms, fnd_lookup_values pay_group, AP_INCOME_TAX_TYPES aptt, po_lookup_codes plc, per_employees_current_x pecx where pv.party_id = hp.party_id AND pv.party_id = pecx.party_id (+) and parent.vendor_id (+) = pv.parent_vendor_id and pv.terms_id = terms.term_id (+) and terms.language (+) = userenv('LANG') and terms.enabled_flag (+) ='Y' and pv.pay_group_lookup_code = pay_group.lookup_code (+) and pay_group.lookup_type (+)='PAY GROUP' and pay_group.language (+)=userenv('lang') and pv.type_1099 = aptt.income_tax_type (+) and pv.VENDOR_TYPE_LOOKUP_CODE = plc.LOOKUP_CODE (+) and plc.lookup_type (+) = 'VENDOR TYPE') QRSLT WHERE (PAY_GROUP_LOOKUP_CODE like '> 2 MILLION%') ORDER BY VENDOR_NAME ASC
  6. 0

    Fnd Load Issue

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;

    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 * 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()
    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:2972)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1852)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      7 frames