oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Clear button Issue
    via by 833116,
  • Fnd Load Issue
    via by Unknown author,
  • SEPL and VO Extension
    via by 567494,
  • Hide/Show within a table
    via by 489141,
  • Getting JBO-25002 for VO substitution
    via by 501447,
  • db:: 3.55::FND_MESSAGE.PUT 1c
    via by Unknown author,
    • 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

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    14 more bugmates