Search Results mtl_category_accounts_v




Overview
Explore in AI Chat

Overview

MTL_CATEGORY_ACCOUNTS_V is an APPS-owned database view in Oracle E-Business Suite, classified under the INV (Inventory) product. The object is marked VALID and carries the description "Retrofitted," indicating it was introduced or re-pointed to preserve backward compatibility with earlier releases of the Inventory cost accounting data model. The view presents category-level and subinventory-level account assignments that govern how inventory transactions are posted to the General Ledger.

The view derives its name and purpose from MTL_CATEGORY_ACCOUNTS, the base table that stores the default account set applied to a given organization, cost group, subinventory, and item category combination. MTL_CATEGORY_ACCOUNTS_V denormalizes that data by joining category, subinventory, cost group, and organization parameter information so that reporting tools and integration programs can resolve human-readable descriptions alongside the raw account identifiers. Its role is primarily a reporting and reference layer: it does not itself drive transaction processing, but it exposes the account configuration used by Cost Management, Inventory, and related subledgers. Users searching for the term "non_invoiced_revenue" reach this view because it exposes the NON_INVOICED_REVENUE column, which is one of the account columns defined for cost accounting and revenue recognition scenarios.

Underlying Base Objects

The documented ETRM metadata lists six referenced base objects, all accessed through APPS synonyms:

The join structure is significant: only the cost group join and the subinventory joins are outer joins, so a row survives even when no matching cost group or secondary inventory exists, but it does not survive a missing category or organization parameter record.

Key Columns

The view exposes the full account column set from MTL_CATEGORY_ACCOUNTS, including MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT, BRIDGING_ACCOUNT, AVERAGE_COST_VAR_ACCOUNT, and the analytical and revenue-related accounts ANALYTICAL_IPV, ANALYTICAL_PO_MIRROR, NON_INVOICED_SO, NON_INVOICED_REVENUE, ANALYTICAL_REVENUE_MIRROR, and ANALYTICAL_MOGS.

Keying and descriptive columns include ORGANIZATION_ID, COST_GROUP_ID, SUBINVENTORY_CODE, CATEGORY_ID, and CATEGORY_SET_ID, together with the standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and concurrent program fields (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE). ROW_ID exposes the underlying MTL_CATEGORY_ACCOUNTS row identifier. Denormalized description columns are CATEGORY_CONCAT_SEGS, MDESC, SDESC, COST_GROUP, and CDESC.

The NON_INVOICED_REVENUE column represents the account used when revenue is recognized on goods that have been shipped but not yet invoiced, supporting accrual and revenue recognition accounting flows.

Common Use Cases and Queries

Typical uses include auditing account configuration by organization and category, validating that revenue and non-invoiced revenue accounts are populated before period close, and feeding downstream integration or reconciliation reports that must map category identifiers to GL account strings.

A representative query retrieving revenue-related account setup for an organization is:

  • SELECT organization_id, cost_group_id, subinventory_code, category_id, category_concat_segs, non_invoiced_revenue, non_invoiced_so, analytical_revenue_mirror FROM mtl_category_accounts_v WHERE organization_id = :org_id;
  • SELECT category_concat_segs, mdesc, sdesc, cost_group, material_account, expense_account FROM mtl_category_accounts_v WHERE organization_id = :org_id AND subinventory_code = :sub_code;
  • SELECT COUNT(*) FROM mtl_category_accounts_v WHERE non_invoiced_revenue IS NULL AND organization_id = :org_id; — used to identify categories lacking a non-invoiced revenue account prior to period-end processing.

Because the view applies an outer join to cost groups and to asset-type subinventories, queries should account for NULL COST_GROUP and SDESC values when interpreting results.