Search Results mtl_category_accounts




Overview
Explore in AI Chat

Overview

INV.MTL_CATEGORY_ACCOUNTS is an Inventory module table that stores the default asset and expense accounting flexfield assignments used at the intersection of item category, cost group, and subinventory within a given inventory organization. It allows Oracle EBS to derive the correct General Ledger accounts automatically during material transactions, cost updates, receiving, and manufacturing activity, rather than relying on a single organization-wide default. Each row effectively answers the question: for this organization, this category, this cost group, and this subinventory, which GL accounts should be charged?

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure suggests this object behaves as a link. It resolves relationships among an organization, a category, a cost group, and a subinventory, while also carrying descriptive accounting attributes. The multiple foreign keys to GL_CODE_COMBINATIONS reinforce that this table bridges operational inventory dimensions to financial accounting dimensions.

Key Information Stored

The primary key, MTL_CATEGORY_ACCOUNTS_PK, is composed of ORGANIZATION_ID, CATEGORY_ID, COST_GROUP_ID, and SUBINVENTORY_CODE. The unique index MTL_CATEGORY_ACCOUNTS_U1 mirrors this business key, confirming that the combination of organization, category, cost group, and subinventory must be unique. The most significant columns include:

Additional columns such as ANALYTICAL_IPV, ANALYTICAL_PO_MIRROR, NON_INVOICED_SO, NON_INVOICED_REVENUE, ANALYTICAL_REVENUE_MIRROR, and ANALYTICAL_MOGS support analytical and mirror accounting scenarios. Standard WHO/audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and concurrent program columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) are also present.

Common Use Cases and Queries

Typical use cases include auditing account mappings per category and subinventory, troubleshooting incorrect GL postings from inventory transactions, and reporting on account assignments for financial reconciliation. A common query joins account columns to GL_CODE_COMBINATIONS to resolve the concatenated account strings:

  • Retrieve all account assignments for a given organization and category, joining to GL_CODE_COMBINATIONS on MATERIAL_ACCOUNT, EXPENSE_ACCOUNT, and related columns.
  • Validate completeness of mappings by comparing against MTL_CATEGORIES_B and MTL_PARAMETERS.
  • Report on subinventory-level overrides versus organization-level defaults.
  • Investigate encumbrance and bridging postings by filtering on ENCUMBRANCE_ACCOUNT and BRIDGING_ACCOUNT.

Related Objects

The following objects are most significant in relation to MTL_CATEGORY_ACCOUNTS, based on the documented foreign key relationships:

  • GL_CODE_COMBINATIONS — referenced by MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT, and BRIDGING_ACCOUNT.
  • MTL_CATEGORIES_B — referenced by CATEGORY_ID; supplies the category definition.
  • MTL_PARAMETERS — referenced by ORGANIZATION_ID; defines the inventory organization.
  • MTL_SYSTEM_ITEMS_B — indirectly related through category assignments used during transaction accounting.
  • MTL_TRANSACTIONS / MTL_MATERIAL_TRANSACTIONS — consume these account mappings during transaction processing.
  • CST_COST_GROUPS — supplies the cost group referenced by COST_GROUP_ID.