Results for “mtl_category_accounts_pk”

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

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:

• ORGANIZATION_ID — identifies the inventory organization; foreign key to MTL_PARAMETERS.
• CATEGORY_ID — the item category; foreign key to MTL_CATEGORIES_B.
• CATEGORY_SET_ID — the category set to which the category belongs, providing structural context.
• COST_GROUP_ID — the cost group dimension within costing.
• SUBINVENTORY_CODE — the subinventory to which the account mapping applies.
• MATERIAL_ACCOUNT — GL account for material valuation; foreign key to GL_CODE_COMBINATIONS.
• MATERIAL_OVERHEAD_ACCOUNT — GL account for material overhead absorption.
• RESOURCE_ACCOUNT — GL account for resource charges.
• OUTSIDE_PROCESSING_ACCOUNT — GL account for outside processing costs.
• OVERHEAD_ACCOUNT — GL account for overhead absorption.
• EXPENSE_ACCOUNT — GL account for expense recognition.
• ENCUMBRANCE_ACCOUNT — GL account used for encumbrance accounting entries.
• BRIDGING_ACCOUNT — GL account used in bridging transactions between inventory and purchasing.
• AVERAGE_COST_VAR_ACCOUNT — GL account for average cost variance postings.

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.