Stock Upload for Item Created – Step-by-Step Guide

Step 1: Verify the Item and Current Stock

First, confirm that the item has been created in the system and check its current stock level.

Make sure the item is assigned to the correct inventory organization for which you intend to upload stock.

Once verified, click Save to confirm the item setup.

Step 2: Check Existing Stock

Navigate to the stock inquiry screen for the item. A blank or zero quantity confirms that no stock exists yet.

💡 Tip: A blank screen on the write-side confirms no stock is currently available for this item — you are now ready to proceed with the upload.

Step 3: Insert Stock Record via MTL_TRANSACTIONS_INTERFACE

Use the following SQL script to insert a stock transaction record into the MTL_TRANSACTIONS_INTERFACE table. Update the values (annotated with comments) to match your environment.

INSERT INTO MTL_TRANSACTIONS_INTERFACE
(
  TRANSACTION_INTERFACE_ID,
  SOURCE_CODE,
  SOURCE_LINE_ID,
  SOURCE_HEADER_ID,
  PROCESS_FLAG,
  VALIDATION_REQUIRED,
  TRANSACTION_MODE,
  LOCK_FLAG,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY,
  INVENTORY_ITEM_ID,
  ORGANIZATION_ID,
  TRANSACTION_QUANTITY,
  TRANSACTION_UOM,
  TRANSACTION_DATE,
  SUBINVENTORY_CODE,
  LOCATOR_ID,
  DISTRIBUTION_ACCOUNT_ID,
  TRANSACTION_TYPE_ID,
  FLOW_SCHEDULE,
  SCHEDULED_FLAG
)
VALUES
(
  MTL_MATERIAL_TRANSACTIONS_S.nextval,  -- TRANSACTION_INTERFACE_ID
  'VIS_LEGACY',                          -- SOURCE_CODE
  1,                                     -- SOURCE_LINE_ID
  1,                                     -- SOURCE_HEADER_ID
  1,                                     -- PROCESS_FLAG
  1,                                     -- VALIDATION_REQUIRED
  3,                                     -- TRANSACTION_MODE
  2,                                     -- LOCK_FLAG
  SYSDATE,                               -- LAST_UPDATE_DATE
  1318,                                  -- LAST_UPDATED_BY
  SYSDATE,                               -- CREATION_DATE
  1318,                                  -- CREATED_BY
  386206,                                -- INVENTORY_ITEM_ID
  204,                                   -- ORGANIZATION_ID
  15,                                    -- TRANSACTION_QUANTITY
  'Ea',                                  -- TRANSACTION_UOM
  TO_DATE('04-10-2024','DD-MM-YYYY'),    -- TRANSACTION_DATE
  'Stores',                              -- SUBINVENTORY_CODE
  NULL,                                  -- LOCATOR_ID
  13401,                                 -- DISTRIBUTION_ACCOUNT_ID
  42,                                    -- TRANSACTION_TYPE_ID
  'Y',                                   -- FLOW_SCHEDULE
  2                                      -- SCHEDULED_FLAG
);

COMMIT;

After inserting, verify the record was created successfully:

SELECT * FROM MTL_TRANSACTIONS_INTERFACE;

Step 4: Launch the Material Transaction Interface Manager

Once your data is inserted and verified, process the transaction by launching the Interface Manager.

a) Switch to your Inventory responsibility.
Navigate to: Setup > Transactions > Interface Managers

b) Select the Material Transaction record.
Click on any column in the row where Name = Material Transaction.

c) Launch the Manager.
Go to: Tools > Launch Manager

d) Click Submit.

The system will begin processing. You should see a confirmation that the interface manager has launched.

Summary

By following the steps above, you can successfully upload opening stock for a newly created item in Oracle Inventory using the MTL_TRANSACTIONS_INTERFACE table. This approach is especially useful for data migration, legacy stock loading, or initial inventory setup scenarios.

Have questions or run into issues? Drop them in the comments below!