My Oracle Support Banner

How to Perform LPN Intransit Org Transfer Through MTL_TRANSACTIONS_INTERFACE and INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS? (Doc ID 2221625.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Warehouse Management - Version 12.2 and later
Oracle Inventory Management - Version 12.2 and later
Information in this document applies to any platform.

Goal

Steps:

  1. Receive LPN-A

  2. Insert into MTL_TRANSACTIONS_INTERFACE
    Refer to below document:
      Sample WMS Open Interface Insert Scripts -- How To Insert Into Transaction Open Interface MTL_TRANSACTIONS_INTERFACE Table (Doc ID 357535.1)
      - Scenario 11: Intransit Org Transfer (No Lot/Serial)
    The sample code in above document is not using LPN.
    Need to populate CONTENT_LPN_ID because LPN is used.
    (Leave LPN_ID and TRANSFER_LPN_ID as null.)

  3. Call INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS API
    Refer to below document:
      How to Perform Miscellaneous Transaction Using API ? (Doc ID 2078693.1)

After performing above steps, we can see:
- Shipment is created.
- LPN context is still showing "In Inventory". LPN context should become to "Intrasit".

If we process the record in MTI by Launch: Process transaction interface (Setup : Transaction Setup : Interfaces : Transaction Interface Manager) instead of Call INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS API,
LPN context becomes to "Intrasit".
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.