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.

  • Migration issue in OAF-urgent
    via by user5425941,
  • Bind Variable in oaf
    via by 839403,
  • handling escape characters in R12 versus 11i
    via by Asmirnov-Oracle,
  • Error when i create a resourse
    via by 882688,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT item_number, item_description, inventory_item_id, billing_type, mtl_transactions_enabled_flag, recovered_part_disp_code, primary_uom_code, recovered_part_disp, transaction_type_id, qrslt.organization_id, restrict_locators_code, update_ib_flag, ib_trackable, location_control_code, lot_control_code, revision_qty_control_code, serial_number_control_code, restrict_subinventories_code, onhand_qty, csp_inv_loc_assignment_id, subinventory_code, resource_type, resource_id, revision, available_qty FROM (SELECT msibk.concatenated_segments item_number, msibk.description item_description, msibk.inventory_item_id, msibk.material_billable_flag billing_type, msibk.mtl_transactions_enabled_flag, msibk.recovered_part_disp_code, msibk.primary_uom_code, fl.meaning recovered_part_disp, DECODE (:1, 'NO_CTBT', -1, ctbt.transaction_type_id) transaction_type_id, msibk.organization_id, msibk.restrict_locators_code, NVL (msibk.comms_nl_trackable_flag, 'N' ) update_ib_flag, NVL (msibk.comms_nl_trackable_flag, 'N') ib_trackable, msibk.location_control_code, msibk.lot_control_code, msibk.revision_qty_control_code, csf_debrief_pvt.serial_number_control_code (msibk.organization_id,msibk.inventory_item_id, 93 ) serial_number_control_code, msibk.restrict_subinventories_code, mosv.total_qoh onhand_qty, cila.csp_inv_loc_assignment_id, cila.subinventory_code, cila.resource_type, cila.resource_id, TO_CHAR (NULL) revision, csp_validate_pub.get_avail_qty (mosv.organization_id,mosv.subinventory_code,NULL,mosv.inventory_item_id, mosv.revision ) available_qty FROM mtl_onhand_sub_v mosv, csp_inv_loc_assignments cila, csp_sec_inventories csi, mtl_parameters mp, mtl_system_items_b_kfv msibk, fnd_lookups fl, (SELECT transaction_type_id, billing_type FROM cs_txn_billing_types WHERE ROWNUM = DECODE (:2, 'NO_CTBT', 1, ROWNUM)) ctbt, cs_billing_type_categories cbtc WHERE mosv.organization_id = cila.organization_id AND mosv.subinventory_code = cila.subinventory_code AND msibk.organization_id = mosv.organization_id AND msibk.inventory_item_id = mosv.inventory_item_id AND mp.organization_id = cila.organization_id AND csi.organization_id = cila.organization_id AND csi.secondary_inventory_name = cila.subinventory_code AND csi.condition_type = 'G' AND msibk.mtl_transactions_enabled_flag = 'Y' AND msibk.recovered_part_disp_code = fl.lookup_code(+) AND fl.lookup_type(+) = 'CSP_RECOVERED_PART_DISP_CODE' AND DECODE (:3, 'NO_CTBT', cbtc.billing_type, ctbt.billing_type ) = cbtc.billing_type AND cbtc.billing_category = 'M' AND cbtc.billing_type = msibk.material_billable_flag AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (msibk.start_date_active, SYSDATE ) ) AND TRUNC (NVL (msibk.end_date_active, SYSDATE)) AND ( ( mp.negative_inv_receipt_code 1 AND mosv.total_qoh > 0 ) OR mp.negative_inv_receipt_code = 1) UNION ALL SELECT msibk.concatenated_segments item_number, msibk.description item_description, msibk.inventory_item_id, msibk.material_billable_flag billing_type, msibk.mtl_transactions_enabled_flag, msibk.recovered_part_disp_code, msibk.primary_uom_code, fl.meaning recovered_part_disp, DECODE (:4,'NO_CTBT', -1, ctbt.transaction_type_id) transaction_type_id, msibk.organization_id, msibk.restrict_locators_code, NVL (msibk.comms_nl_trackable_flag, 'N' ) update_ib_flag, NVL (msibk.comms_nl_trackable_flag, 'N') ib_trackable, msibk.location_control_code, msibk.lot_control_code, msibk.revision_qty_control_code, csf_debrief_pvt.serial_number_control_code (msibk.organization_id, msibk.inventory_item_id, 93 ) serial_number_control_code, msibk.restrict_subinventories_code, 0 onhand_qty, cila.csp_inv_loc_assignment_id, cila.subinventory_code, cila.resource_type, cila.resource_id, TO_CHAR (NULL) revision, 0 available_qty FROM mtl_system_items_b_kfv msibk, csp_inv_loc_assignments cila, csp_sec_inventories csi, mtl_parameters mp, fnd_lookups fl, (SELECT transaction_type_id, billing_type FROM cs_txn_billing_types WHERE ROWNUM = DECODE (:5, 'NO_CTBT', 1, ROWNUM)) ctbt, cs_billing_type_categories cbtc WHERE mp.organization_id = cila.organization_id AND mp.negative_inv_receipt_code = 1 AND msibk.organization_id = cila.organization_id AND csi.organization_id = cila.organization_id AND csi.secondary_inventory_name = cila.subinventory_code AND csi.condition_type = 'G' AND msibk.mtl_transactions_enabled_flag = 'Y' AND msibk.recovered_part_disp_code = fl.lookup_code(+) AND fl.lookup_type(+) = 'CSP_RECOVERED_PART_DISP_CODE' AND DECODE (:6, 'NO_CTBT', cbtc.billing_type, ctbt.billing_type ) = cbtc.billing_type AND cbtc.billing_category = 'M' AND cbtc.billing_type = msibk.material_billable_flag AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (msibk.start_date_active, SYSDATE ) ) AND TRUNC (NVL (msibk.end_date_active, SYSDATE) ) AND NOT EXISTS ( SELECT 'x' FROM mtl_onhand_quantities_detail moqd WHERE moqd.organization_id = msibk.organization_id AND moqd.inventory_item_id = msibk.inventory_item_id AND moqd.subinventory_code = cila.subinventory_code) ORDER BY item_number) qrslt, c_csd_global_temp_sbom_items sbom WHERE qrslt.resource_type = :7 AND qrslt.resource_id = :8 AND qrslt.organization_id IN (418) AND qrslt.csp_inv_loc_assignment_id IN (10060) AND qrslt.transaction_type_id = :9 AND qrslt.update_ib_flag = DECODE (:10, 'N', 'N', qrslt.update_ib_flag ) AND qrslt.organization_id = sbom.organization_id AND qrslt.inventory_item_id = sbom.component_item_id) qrslt WHERE ((UPPER (item_number) LIKE UPPER (:11))) 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:2978) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875) 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