OM RMA Issue (Not able to Receive an RMA in Inventory)

Once in a while I came across some simple and stupid issue.

Recently my customer escalated one issue that he is not able to receive RMA against a Sales Orders. His issue was After Entering and BOOKING RMA , he was not able to receive item in the warehouse and there were 500 + such cases.


Issue here was not very sesious.Customer created Sales Order with Warehouse W1 and shipped the good, and then they created RMA for same item in W2 and book , but not able to receive.


We had built lot of customization above the Oracle Standard functionality and initially we thought it is may because of that .After going though pain of scanning all custom code if found nothing in custom code.


I have tried couple of test cases and found that I was able to Book and receive RMA in warehouse W1, and now question was why not in W2.And to my surprise I found that particular Item was not assign to warehouse W2. And FIX was just assign the item to warehouse W2.

Technical Solution
---------------------
SELECT l.shippable_flag,m.shippable_item_flag
   mtl_transactions_enabled_flag 
    FROM mtl_system_items m, oe_order_lines_all l 
    WHERE m.inventory_item_id = l.inventory_item_id 
    AND m.organization_id = l.ship_from_org_id 
    AND l.line_id = &Enter_Order_line_id
--------------------
Execute the above query and if it return data then that means item is assign to warehouse , but if above query don't return any data then go and assign item to required warehouse.

In the above query I am checking  conditions
-----------
m.inventory_item_id = l.inventory_item_id 
    AND m.organization_id = l.ship_from_org_id
-----------
to validate if item that define in ship_from_org_id in RMA is assign to the Inventory organization in INVENTORY