OracleFree referencePDF, Excel, Word exportOracle E-Business SuiteDiscrete Manufacturing

Oracle EBS Inventory Transaction Types Reference

Every row in MTL_MATERIAL_TRANSACTIONS carries a TRANSACTION_TYPE_ID that tells you what happened and why on-hand moved. This table lists the common types so you can read transaction history and write reports without guessing.

Download:

Type ID	Transaction type	Typical source	On-hand effect	Raised from
1	Account issue	Account	Decreases on-hand	Inventory
2	Subinventory Transfer	Inventory	Moves between subinventories, org total unchanged	Inventory
3	Direct Org Transfer	Inventory	Decreases source org, increases destination org	Inventory
4	Cycle Count Adjustment	Cycle count	Increases or decreases to match count	Inventory
8	Physical Inventory Adjustment	Physical inventory	Increases or decreases to match count	Inventory
12	Intransit Receipt	Inventory	Increases on-hand in receiving org	Inventory
15	RMA Receipt	RMA	Increases on-hand	Order Management
17	WIP Assembly Return	Job or schedule	Decreases on-hand of the assembly	WIP
18	PO Receipt	Purchase order	Increases on-hand when delivered to inventory	Purchasing
21	Intransit Shipment	Inventory	Decreases on-hand in shipping org	Inventory
31	Account alias issue	Account alias	Decreases on-hand	Inventory
32	Miscellaneous issue	Account	Decreases on-hand	Inventory
33	Sales order issue	Sales order	Decreases on-hand at ship confirm	Order Management
35	WIP Issue	Job or schedule	Decreases component on-hand	WIP
38	WIP Negative Component Issue	Job or schedule	Increases component on-hand	WIP
41	Account alias receipt	Account alias	Increases on-hand	Inventory
42	Miscellaneous receipt	Account	Increases on-hand	Inventory
43	WIP Component Return	Job or schedule	Increases component on-hand	WIP
44	WIP Completion	Job or schedule	Increases assembly on-hand	WIP
52	Backflush Transfer	Job or schedule	Transfers backflush components from supply subinventory	WIP

IDs below 10000 are seeded system types, and user-defined types start from higher numbers. Confirm against MTL_TRANSACTION_TYPES on your instance, since some types are only present when the related module is installed.

Explain on-hand movements in plain English

Optional: we can show how a read-only assistant explains material transactions from your EBS data.

Optional. The tool and every export work without this. No spam.

How to use this reference

Search by name or by ID. When you are debugging an on-hand discrepancy, filter MTL_MATERIAL_TRANSACTIONS by item and organization, then use this table to translate the TRANSACTION_TYPE_ID values into plain language. Export to Excel to add the descriptions next to a data extract that you hand to a cost accountant.

Type, action and source

A transaction in Oracle Inventory is defined by three things: the transaction type, the transaction action, and the transaction source type. The type is the business event, the action says whether it issues, receives or transfers, and the source type points to the document, such as a job, purchase order or sales order. User-defined types are built from a seeded action and source type pair.

Transaction type: the named business event
Transaction action: issue, receipt, transfer, adjust
Source type: job, PO, sales order, account, alias
Source ID points to the specific document

Reading the on-hand effect

Subinventory transfers do not change organization on-hand, but they do change what is available in a given subinventory and locator. Direct org transfers and intransit shipments change both. WIP issues and returns affect components, while completions and assembly returns affect the finished item. Reconcile these against the accounting entries in MTL_TRANSACTION_ACCOUNTS.

Common mistakes

People often treat a miscellaneous issue as equivalent to a scrap or a WIP return, which breaks cost traceability. Another mistake is hard-coding type IDs in custom code, even though IDs for user-defined types differ between instances. Join to MTL_TRANSACTION_TYPES by name or ID from the same instance instead.

Frequently Asked Questions

Where are Oracle inventory transaction types stored?

They live in MTL_TRANSACTION_TYPES, with the name in TRANSACTION_TYPE_NAME and the action and source type in related columns. Material movements are in MTL_MATERIAL_TRANSACTIONS.

Can I create my own transaction type?

Yes. In the Transaction Types window you can define a user type from a seeded transaction action and source type. It is the supported way to separate, for example, a scrap issue from a general miscellaneous issue.

What is the difference between WIP Issue and Backflush?

WIP Issue is a manual or push issue of components to a job. Backflush Transfer and the related issues happen automatically when assemblies are completed or operations are moved, based on the supply type.

Why do some IDs differ in my instance?

Seeded IDs are standard, but user-defined types get new IDs per instance. Always join on the table in your own database rather than relying on a copied list.

If you often explain on-hand movements to finance, we can build an assistant on your EBS data that reads transaction history and explains it in words.

Talk to an Expert Explore More Free Tools

Related Tools

Oracle

More Oracle tools

See all

Back to All Tools