Pages

Wednesday 2 May 2012

Transaction process error - "Inventory Module"

Issue Description: After Release Sales Order For Picking process, the item traded remained in the subinventory transfer and we have the Error: "Transaction processor error" and Transaction Mode: "Background processing" and Error Explanation: "Ex.. in BaseTransaction calling Relieve Reservations ..:oracle.apps.inv.transaction.utilities.InvTrxException". Even if the item is locked in interface, invoice came out.


Solution:
After a long search on metalink.oracle.com, OTN, and google, I found these notes useful in this case, but me not helped:
ID 280400.1  - Stuck Transaction Interface Sales Order Issues: An Error Occured While Relieving Reservations (INV_RSV_RLF_FAILED)
ID 437292.1  Misc Issue Fails in Transaction Open Interface with Error: "An error occurred while relieving reservations"


And return to solution, as we managed to do:


1. We run the request: "Interface Trip Stop" - ends in error...
2. Run procedure: "APPS.RelieveReservation" - we get rid of reservations...
3. We run again the request: "Interface Trip Stop"
----Carefully attempting something like that fits below----



UPDATE wsh_delivery_details
  SET INV_INTERFACED_FLAG ='N',
  transaction_temp_id = mtl_material_transactions_s.nextval
  WHERE delivery_detail_id = &delivery_detail_id;


UPDATE mtl_serial_numbers
  SET group_mark_id = mtl_material_transactions_s.currval,CURRENT_STATUS = 3
  WHERE inventory_item_id = &inventory_item_id
  AND SERIAL_NUMBER = '*1'
  AND CURRENT_STATUS = 6
  AND CURRENT_SUBINVENTORY_CODE = '&subinventory_code';

  select * from wsh_delivery_details
    where subinventory=' &subinventory_code '
    and inventory_item_id=&inventory_item_id
    and source_header_number=&surce_number;
 
    select * from mtl_serial_numbers
    WHERE inventory_item_id = &inventory_item_id
  AND SERIAL_NUMBER = '*1'
   AND CURRENT_STATUS = 6
  AND CURRENT_SUBINVENTORY_CODE = ' &subinventory_code';

  select * from mtl_lot_numbers
    WHERE inventory_item_id =  &inventory_item_id;
---check if there
select distinct wdd.source_header_number "Order Number",
wnd.delivery_id,
wts.stop_id,
wts.trip_id,
wts.creation_date,
wnd.Organization_id,
wnd.INITIAL_PICKUP_LOCATION_ID,
wdd.Picked_Quantity,
wdd.Item_Description
from
wsh_delivery_details wdd,
wsh_delivery_assignments wda,
wsh_new_deliveries wnd,
wsh_delivery_legs wdl,
wsh_trip_stops wts
where
wdd.source_code = 'OE'
and wdd.released_status = 'C'
and (wdd.oe_interfaced_flag in ('N','P') or wdd.inv_interfaced_flag in ('N','P'))
and wdd.delivery_detail_id = wda.delivery_detail_id
and trunc(wdd.creation_date) > sysdate -365
and wda.delivery_id = wnd.delivery_id
and wnd.delivery_id = wdl.delivery_id
and wdl.pick_up_stop_id = wts.stop_id
and nvl(wts.pending_interface_flag,'X') <> 'Y'
order by 1;


update wsh_trip_stops
set pending_interface_flag = 'Y'
where stop_id = &stop_id;

select pending_interface_flag from  wsh_trip_stops
where  stop_id =
&stop_id;

No comments:

Post a Comment