Scribd
Upload
23 views3 pages

MTL Transaction Lots Interface Overview

The document outlines the inventory on-hand quantity interface, detailing the necessary interface tables such as MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE, and MTL_SERIAL_NUMBERS_INTERFACE. It specifies the concurrent program to launch the Transaction Manager and highlights important columns that must be populated in the interface tables. Additionally, it lists base tables including MTL_ON_HAND_QUANTITIES and provides key data points for transaction processing.

Uploaded by

haribaskari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
23 views3 pages

MTL Transaction Lots Interface Overview

The document outlines the inventory on-hand quantity interface, detailing the necessary interface tables such as MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE, and MTL_SERIAL_NUMBERS_INTERFACE. It specifies the concurrent program to launch the Transaction Manager and highlights important columns that must be populated in the interface tables. Additionally, it lists base tables including MTL_ON_HAND_QUANTITIES and provides key data points for transaction processing.

Uploaded by

haribaskari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Inventory On-hand quantity Interface:

Interface tables:

MTL_TRANSACTIONS_INTERFACE MTL_MTL_TRANSACTION_LOTS_INTERFACE (If


the item is Lot Controlled) MTLL_SERIAL_NUMBERS_INTERFACE (If the item is Serial
Controlled)

Concurrent Program:

Launch the Transaction Manager through Interface Manager (or) explicitly call the
API – INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS () to launch a dedicated
transaction worker to process them.

Base Tables:

MTL_ON_HAND_QUANTITIES

MTL_LOT_NUMBERS

MTL_SERIAL_NUMBERS

Some important columns that need to be populated in the interface tables:

MTL_TRANSACTIONS_INTERFACE:

TRANSACTION_SOURCE_NAME (ANY USER DEFINED VALUE),

TRANSACTION_HEADER_ID (MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL),

TRANSACTION_INTERFACE_ID (MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL – If item is lot or serial


controlled, use this field to link to ‘mtl_transactions_interface’ otherwise leave it as NULL),

TRANSACTION_DATE,

TRANSACTION_TYPE_ID,

PROCESS_FLAG (1 = Yet to be processed, 2 = Processed, 3= Error),

TRANSACTION_MODE,

SOURCE_CODE,

SOURCE_HEADER_ID,

SOURCE_LINE_ID,

TRANSACTION_SOURCE_ID,

ITEM_SEGMENT1 TO 20,
TRANSACTION_QTY,

TRANSACTION_UOM,

SUBINVENTORY_CODE,

ORGANIZATION_ID,

LOC_SEGMENT1 TO 20.

MTL_TRANSACTION_LOTS_INTERFACE:

TRANSACTION_INTERFACE_ID,

LOT_NUMBER,

LOT_EXPIRATION_DATE,

TRANSACTION_QUANTITY,

SERIAL_TRANSACTION_TEMP_ID (This is required for items under both lot and serial control to
identify child records in mtl_serial_numbers_interface).

MTL_SERIAL_NUMBERS_INTERFACE:

TRANSACTION_INTERFACE_ID,

FM_SERIAL_NUMBER,

TO_SERIAL_NUMBER,

VENDOR_SERIAL_NUMBER

You might also like