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

Oracle Community | 1010599 | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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
  2. 0

    Null pointer exception while  extending OrderCO

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

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

    Oracle Community | 7 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)))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Clear button Issue

    Oracle Community | 6 years ago | 833116
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    Fnd Load Issue

    wpthm.com | 2 years 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 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

      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