Search Results mtl_fiscal_cat_accounts




Overview
Explore in AI Chat

Overview

MTL_FISCAL_CAT_ACCOUNTS is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores category account definitions for a legal entity. It defines the default general ledger account assignment used when inventory transactions, receipts, and costed events are processed for a given item category. The table links a legal entity, a cost type, a cost group, and an inventory category to a set of General Ledger Code Combinations, thereby governing which account balances are impacted during inventory valuation and accounting.

Under the heuristic Data Vault classification mined from the foreign key structure, this table is modelled as a link. It connects independent hub entities — the legal entity, cost type, cost group, and category — to GL account references, and is therefore best represented as an intersection or relationship satellite rather than a hub or a descriptive satellite.

Key Information Stored

The table contains 18 documented columns. The most significant are the four key columns that form the primary key and the accounting columns that determine posting behaviour:

The surrogate primary key is MTL_FISCAL_CAT_ACCOUNTS_PK, defined over LEGAL_ENTITY_ID, COST_TYPE_ID, COST_GROUP_ID, and CATEGORY_ID. The unique index MTL_FISCAL_CAT_ACCOUNTS_U1 covers the same four columns and therefore serves as the business-key candidate. Standard audit columns include LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage includes verifying default accounting rules for a category, diagnosing account derivation issues during inventory accounting, and reconciling subledger-to-GL transfers. A representative query joins the table to GL_CODE_COMBINATIONS to resolve the underlying account segments:

  • SELECT mfc.legal_entity_id, mfc.cost_type_id, mfc.cost_group_id, mfc.category_id, gcc.concatenated_segments
  • FROM mtl_fiscal_cat_accounts mfc, gl_code_combinations_kfv gcc
  • WHERE mfc.material_account = gcc.code_combination_id;

Reporting scenarios include listing all account assignments for a legal entity, auditing cost group and cost type combinations, and validating that every category has a bridging and expense account configured before period close.

Related Objects

The following objects are most significant in relation to MTL_FISCAL_CAT_ACCOUNTS:

  • HR_ALL_ORGANIZATION_UNITS — joined on LEGAL_ENTITY_ID to resolve legal entity details.
  • CST_COST_TYPES — joined on COST_TYPE_ID.
  • CST_COST_GROUPS — joined on COST_GROUP_ID.
  • MTL_CATEGORIES_B — joined on CATEGORY_ID to resolve category names and descriptions.
  • GL_CODE_COMBINATIONS — referenced by MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OVERHEAD_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, EXPENSE_ACCOUNT, and BRIDGING_ACCOUNT.

These relationships make MTL_FISCAL_CAT_ACCOUNTS a pivotal reference table for inventory accounting configuration within Oracle EBS.