Oracle Physical Inventory Adjustment Process and Data flow.

1. Create an item and subinventory for the test case of physical subinventory adjustment

2. Misc receipt some onhand for the item, in the new created subinventory (named PhySub)

3. Create the Physical Inventory

    Routing: Inventory > Counting > Physical Inventory > Physical Inventories

   

    after the save the physical subinventory

    there is a record insert into MTL_PHYSICAL_INVENTORIES

    SELECT * FROM mtl_physical_inventories
    WHERE physical_inventory_id=2194;

4. Inventory > Counting > Physical Inventory > Tag Generation

  

  

5. Inventory > Counting > Physical Inventory > Tag Counts

SELECT * FROM mtl_physical_inventory_tags
  WHERE tag_id IN (2865,2866);

6. Inventory > Counting > Physical Inventory Approve Adjustments

SELECT * FROM mtl_physical_adjustments
WHERE adjustment_id IN (4082,4083);

7. Inventory > Counting > Physical Inventory

    Tool > Launch Adjustment

   

    After launch adjustment, related records will be inserted into MMTT, then processed as MMT.

    Then check out the MMT information:

    SELECT * FROM mtl_material_transactions
    WHERE transaction_id=23612344;

    the transaction_source_type id, transaction_type_id and transaction_action_id are 10, 8, 8