Fusion Reference

INV_TRANSACTION_TYPES_B

Product: INVcontrol

The transaction type list — seeded and user-defined types, each mapping to the transaction action and source type that together classify material transactions

Identity

Module: InventoryNot org-partitioned

EBS equivalents (2)

MTL_MATERIAL_TRANSACTIONS MTL_TRANSACTION_TYPES

Notes

Global reference data — no org column. The type NAME is not on this table at all — it lives only on the translation companion (INV_TRANSACTION_TYPES_TL, not yet cataloged), so readable transaction-type output is language-filtered. USER_DEFINED_FLAG separates site-defined types from seeded ones; TRANSACTION_ACTION_ID is a VARCHAR2 code here, unlike its EBS ancestor.

What the badges mean

Product: EGP: Product: the Oracle product family that owns the object — the short code Oracle's Tables and Views documentation lists as the object owner. Fusion is SaaS, so this isn't a database schema; there's no SQL path to the tables at all (see the quirks guide).
master: Data class: what the table holds — master data, transaction documents, control/configuration, interface/staging, or a documented view.
BU-striped (ORG_ID): Rows are scoped to a business unit. The column is still named ORG_ID, but in Fusion it means business unit, not the EBS operating unit — treat any migrated “operating unit” filter as suspect (see the quirks guide).
Per inventory org: Rows are scoped to an inventory organization via ORGANIZATION_ID — always pair it with INVENTORY_ITEM_ID on item-level joins (see the quirks guide).
Set / ledger / named-BU striped: Some tables stripe by a named column instead of ORG_ID: reference data set (SET_ID — see the quirks guide), ledger (LEDGER_ID on the GL journal tables), or a named business-unit column (PRC_BU_ID / REQ_BU_ID in procurement). The table page’s partition line names the column, and the generated SQL anchors on it — never treat these tables as unpartitioned.
Language-striped: The table carries a LANGUAGE column (a _TL translation table or FND_LOOKUP_VALUES) — one row per language. Filter to one LANGUAGE or a join multiplies rows.
Date-effective: This is an _F table — one row per entity per effectivity window, with EFFECTIVE_START_DATE and EFFECTIVE_END_DATE part of the key. Join without a window filter and every fact multiplies by history (see the quirks guide).
View: This is a documented convenience view, not a physical table. Extract through the BICC data store that fronts its base objects instead of assuming the view lands as-is.

Extract access

The delivered surfaces that reach this table — the BICC extract data store (PVO) for bulk extraction and the OTBI subject areas for real-time queries. There is no SQL path to the SaaS database.

FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvTxnTypeExtractPVO
OTBI: Inventory - Inventory Transactions Real Time
Keyed on TransactionTypeId. In OTBI, the transaction type is a dimension of the transactions subject area.
Oracle data-store documentation (opens in new tab)
FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvTxnTypeTLExtractPVO
The translated type names (Language + TransactionTypeId) — covers the _TL companion this catalog doesn't list separately; needed because the base table has no name column.
Oracle data-store documentation (opens in new tab)

Fields

9 fields · 1 key

9 fields.

Table fields: position, field name, description, data type, and flags. 9 fields.
#	Field	Description	Type	Flags
1	TRANSACTION_TYPE_ID	Transaction-type surrogate key	NUMBER	Key
2	TRANSACTION_ACTION_ID	Underlying action (issue, receipt, transfer) — a VARCHAR2 code in the Fusion dictionary	VARCHAR2
3	TRANSACTION_SOURCE_TYPE_ID	Source-type the type is bound to (PO, sales order, account…)	NUMBER
4	USER_DEFINED_FLAG	Y for site-defined types — treat their ids as configuration, not constants	VARCHAR2
5	START_DATE	When the type becomes usable	DATE
6	END_DATE	When the type is retired	DATE
7	TYPE_CLASS	Marks project-related transaction types	NUMBER
8	STATUS_CONTROL_FLAG	Whether material-status control applies to the type	NUMBER
9	LOCATION_REQUIRED_FLAG	Whether a location is mandatory on the transaction	VARCHAR2

Field provenance: hand-curated. 1 key field.

Boilerplate SQL

Starting point for reading the BICC-landed copy of INV_TRANSACTION_TYPES_B on Databricks — real DATE columns need no conversion, and the org anchor and the LAST_UPDATE_DATE watermark (the column incremental BICC extracts key on) are already in place. Set your Unity Catalog location, schema, and org values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaTransaction typewatermark

Include optional filters (2)

4 parameters not filled: <catalog>, <schema>, <TRANSACTION_TYPE_ID>, <watermark>

-- ============================================================
-- Table  : INV_TRANSACTION_TYPES_B — The transaction type list — seeded and user-defined types, each mapping to the transaction action and source type that together classify material transactions
-- Purpose: Column-selected read of INV_TRANSACTION_TYPES_B — auto-generated from field metadata
-- Grain  : One row per TRANSACTION_TYPE_ID
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.TRANSACTION_TYPE_ID AS "Transaction-type surrogate key",
  t.TRANSACTION_ACTION_ID AS "Underlying action (issue, receipt, transfer) — a VARCHAR2 code in the Fusion dictionary",
  t.TRANSACTION_SOURCE_TYPE_ID AS "Source-type the type is bound to (PO, sales order, account…)",
  t.USER_DEFINED_FLAG AS "Y for site-defined types — treat their ids as configuration, not constants",
  t.START_DATE AS "When the type becomes usable",
  t.END_DATE AS "When the type is retired",
  t.TYPE_CLASS AS "Marks project-related transaction types",
  t.STATUS_CONTROL_FLAG AS "Whether material-status control applies to the type",
  t.LOCATION_REQUIRED_FLAG AS "Whether a location is mandatory on the transaction"
FROM <catalog>.<schema>.INV_TRANSACTION_TYPES_B t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.TRANSACTION_TYPE_ID = <TRANSACTION_TYPE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.TRANSACTION_TYPE_ID;

Verified September 2026 · docs release 26C

Column names differ in BICC extracts — see PVO header drift.

Relationships

Diagram of 1-hop neighbors — join details below. FND lookup decode and translation edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

INV_MATERIAL_TXNSINV_TRANSACTION_TYPES_Bforeign key · N:1
ON INV_MATERIAL_TXNS.TRANSACTION_TYPE_ID = INV_TRANSACTION_TYPES_B.TRANSACTION_TYPE_ID
INV_TXN_REQUEST_LINESINV_TRANSACTION_TYPES_Bforeign key · N:1
ON INV_TXN_REQUEST_LINES.TRANSACTION_TYPE_ID = INV_TRANSACTION_TYPES_B.TRANSACTION_TYPE_ID

Browse more Inventory tables