Results for “document_header_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_KANBAN_CARD_ACTIVITY is an Inventory (INV) module table that records the transactional history and current activity state of Kanban cards within Oracle E-Business Suite Release 12.1.1 and 12.2.2. In a Kanban replenishment environment, each card represents a replenishment signal tied to an inventory item, subinventory, or external source. This table captures the lifecycle events generated when those cards are processed, replenished, or reported on by the Kanban planning engine and related transaction flows.

The table is owned by the INV schema and is documented as VALID in ETRM. It is a child of MTL_KANBAN_CARDS and serves as the activity ledger that links Kanban cards to the demand documents they generate, such as purchase orders, requisitions, move orders, and work in process entities. Under the heuristic Data Vault classification derived from its foreign key structure, this object is modeled as a link table. It connects multiple business hubs — items, Kanban cards, suppliers, organizations, and source documents — through its foreign keys, and its identity is anchored by the surrogate key KANBAN_ACTIVITY_ID.

Key Information Stored

The table contains 50 documented columns. The most significant are summarized below.

• KANBAN_ACTIVITY_ID — The surrogate primary key, backed by the unique index MTL_KANBAN_CARD_ACTIVITY_U1 and constraint MTL_KANBAN_CARD_ACTIVITY_PK. Each row represents one Kanban activity event.
• KANBAN_CARD_ID — Foreign key to MTL_KANBAN_CARDS, tying the activity to its originating card.
• KANBAN_CARD_NUMBER — The human-readable card number, useful for operational reporting without a join.
• REPLENISHMENT_CYCLE_ID — Identifies the replenishment cycle associated with the activity.
• INVENTORY_ITEM_ID and ORGANIZATION_ID — The item and inventory organization context, referencing MTL_SYSTEM_ITEMS_B and MTL_PARAMETERS respectively.
• SUPPLY_STATUS and CARD_STATUS — The current state of the card from supply and card perspectives.
• KANBAN_CARD_TYPE and SOURCE_TYPE — Classify the card and its replenishment source (for example, supplier, move order, or WIP).
• DOCUMENT_TYPE, DOCUMENT_HEADER_ID, and DOCUMENT_DETAIL_ID — The polymorphic reference to the generated demand or supply document, which may resolve to PO_HEADERS_ALL, PO_REQUISITION_HEADERS_ALL, MTL_TXN_REQUEST_HEADERS, WIP_ENTITIES, or their detail counterparts.
• SUPPLIER_ID and SUPPLIER_SITE_ID — Supplier context for externally sourced cards, referencing PO_VENDORS and PO_VENDOR_SITES_ALL.
• SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY, and SOURCE_LOCATOR_ID — Define the replenishment source location for move-order style cards.
• WIP_LINE_ID and SOURCE_WIP_ENTITY_ID — WIP context for cards sourced from discrete jobs or repetitive schedules.
• ERROR_CODE — Captures processing errors during card activity execution.
• LAST_PRINT_DATE — Tracks the most recent card print action.

Common Use Cases and Queries

The table supports Kanban performance analysis, replenishment cycle tracking, and operational error diagnosis. A typical query retrieves recent activity for a card in an organization:

• Listing activity by card: SELECT kanban_activity_id, kanban_card_number, card_status, supply_status, document_type FROM mtl_kanban_card_activity WHERE kanban_card_id = :card_id ORDER BY creation_date DESC;
• Identifying failed activities: SELECT kanban_activity_id, kanban_card_number, error_code FROM mtl_kanban_card_activity WHERE error_code IS NOT NULL;
• Joining to source documents to reconcile replenishment: join DOCUMENT_HEADER_ID to PO_HEADERS_ALL or MTL_TXN_REQUEST_HEADERS, filtered by DOCUMENT_TYPE.
• Reporting card activity volume by organization and item for replenishment tuning.

Related Objects

The following objects are most significant, based on documented foreign keys.

• MTL_KANBAN_CARDS — Parent card definition via KANBAN_CARD_ID.
• MTL_SYSTEM_ITEMS_B — Item master via INVENTORY_ITEM_ID.
• MTL_PARAMETERS — Organization context via ORGANIZATION_ID.
• MTL_SECONDARY_INVENTORIES — Subinventory and source subinventory references.
• PO_HEADERS_ALL / PO_DISTRIBUTIONS_ALL — Purchase order demand documents.
• PO_REQUISITION_HEADERS_ALL / PO_REQUISITION_LINES_ALL — Requisition documents.
• MTL_TXN_REQUEST_HEADERS / MTL_TXN_REQUEST_LINES — Move order documents.
• WIP_ENTITIES / WIP_LINES — Work in process demand references.
• PO_VENDORS / PO_VENDOR_SITES_ALL — Supplier and supplier site references.