Oracle eBS經驗分享

Issue Description:
Organization : HKG
Action : Subinventory Transfer
Error : LPN is allocated

1. Entry LPN
2. {Tab}
3. Error pop

Root Cause

My Solution is

1. backup data
INSERT INTO appsr.xxdii_mmtt
   SELECT *
     FROM mtl_material_transactions_temp
    WHERE organization_id = 93 AND lpn_id = 984448;

INSERT INTO appsr.xxdii_mtlt
   SELECT *
     FROM mtl_transaction_lots_temp
    WHERE transaction_temp_id IN (165197121, 165197126, 165197134);
commit;

2. Clear pending transaction data
DELETE FROM mtl_transaction_lots_temp
      WHERE transaction_temp_id IN (165197121, 165197126, 165197134);

DELETE FROM mtl_material_transactions_temp
      WHERE transaction_temp_id IN (165197121, 165197126, 165197134);
commit;

3. Try it again.

  Success !!