Symptoms and solutions for material retention errors during OracleEBS sales

Previously, in OracleEBSR12, I encountered a material retention error when a sales order was shipped. As a result, the interface error occurred while handling the materials and shipping transactions could not be handled. Background: Sales

Previously, in Oracle EBS R12, I encountered a material retention error when the sales order was shipped. As the material processing interface error and shipping transaction failed to handle the problem, Background: Sales

SELECT oeh.org _ id ou_id,
Hou. NAME ou_name,
Mso. concatenated_segments header_number,
Oel. line_number | '.' | oel. shipment_number |
Decode (oel. option_number, NULL, NULL, '.' | oel. option_number) |
Decode (oel. component_number, NULL, NULL, '.' | oel. component_number) |
Decode (oel. service_number, NULL, NULL, '.' | oel. service_number) line,
Mst. segment1 item_code,
Oel. flow_status_code status_code,
Lov. meaning status_name,
CLR. organization_id,
Ood. organization_code,
Ood. organization_name,
CLR. subinventory_code,
CLR. requirement_date,
CLR. reservation_quantity,
CLR. reservation_uom_code,
CLR. staged_flag,
Oel. ordered_quantity,
Oel. shipped_quantity,
Oel. shipping_quantity
FROM inv. mtl_reservations CLR,
Inv. mtl_system_items_ B mst,
Apps. mtl_sales_orders_kfv mso,
Ont. oe_order_lines_all oel,
Ont. oe_order_headers_all oeh,
Apps. fnd_lookup_values_vl lov,
Choose .org _ organization_definitions ood,
Apps. hr_operating_units hou
Where clr. organization_id = mst. organization_id
And clr. inventory_item_id = mst. inventory_item_id
And clr. demand_source_header_id = mso. sales_order_id
And clr. demand_source_line_id = oel. line_id
AND oel. header_id = oeh. header_id
AND lov. lookup_type = 'line _ FLOW_STATUS'
AND oel. flow_status_code = lov. lookup_code
And clr. organization_id = ood. organization_id
AND oeh.org _ id = hou. organization_id
And clr. demand_source_type_id = 2 -- requirement 2 is the sales order. For details, see inv. mtl_txn_source_types.
AND respiratory. supply_source_type_id = 13 -- supply 13 is inventory. For details, see inv. mtl_txn_source_types.
And clr. reservation_quantity = 0 -- the number is 0.
AND nvl (CLR. staged_flag, 'n') <> 'y' -- not to be released
AND oel. flow_status_code = 'awaiting _ shipping' -- the status is waiting for shipment.
AND oeh.org _ id = 88
Order by hou. NAME, ood. organization_code