Search Results ax_mtl_category_accounts_v1

Overview

The view AX_MTL_CATEGORY_ACCOUNTS_V1 belongs to the Global Accounting Engine (AX) product family in Oracle E-Business Suite. Its documented purpose is to resolve material accounts by subinventory code or cost group, exposing the full set of accounting flexfield assignments configured at the category level for a given inventory organization and item. In 12.1.1 and 12.2.2, the Global Accounting Engine provides subledger accounting and analytical reporting for inventory and manufacturing transactions, and this view functions as a thin, denormalized layer over the MTL_CATEGORY_ACCOUNTS table joined to the item-category intersection.

Because it exposes both item-level and category-level account assignments in a single row, the view is used principally by accounting reports, reconciliation extracts, and integration programs that must determine the correct material, overhead, resource, and analytical accounts before posting or mirroring a transaction. Note that the metadata records the view as "Not implemented in this database," meaning that in some EBS instances the object is shipped as a script or dictionary definition but not instantiated; consumers should verify its existence before depending on it.

Underlying Base Objects

Although the documented "Referenced base objects" list is empty, the view text itself establishes the dependency. Three tables participate:

• MTL_CATEGORY_ACCOUNTS (alias MCA) — the driving table holding the accounting flexfield assignments keyed by organization, category, and subinventory or cost group.
• MTL_CATEGORY_SETS (alias MCS) — filters the join to the category set named 'ACCOUNTING'.
• MTL_ITEM_CATEGORIES (alias MIC) — supplies the inventory item to category assignment, joining on category set, category, and organization.

The join condition correlates all three tables on CATEGORY_SET_ID and CATEGORY_ID, and correlates MCA to MIC on ORGANIZATION_ID. The hard-coded predicate MCS.CATEGORY_SET_NAME = 'ACCOUNTING' restricts output to assignments defined within the Accounting category set.

Key Columns

The view projects eighteen columns. The principal keys and identifiers are:

• ORGANIZATION_ID — inventory organization owning the assignment.
• SUBINVENTORY_CODE — the subinventory to which the assignment applies, where configured by subinventory.
• COST_GROUP_ID — cast to character via TO_CHAR, identifying the cost group when the assignment is cost-group based rather than subinventory based.
• INVENTORY_ITEM_ID — the item resolved through MTL_ITEM_CATEGORIES.

The remaining columns are account identifiers: MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT, and BRIDGING_ACCOUNT. A final group supports analytical/AX-specific postings: ANALYTICAL_IPV, ANALYTICAL_PO_MIRROR, NON_INVOICED_SO, NON_INVOICED_REVENUE, ANALYTICAL_REVENUE_MIRROR, and ANALYTICAL_MOGS.

Common Use Cases and Queries

Typical usage includes verifying that a given item resolves to the intended material account in a specific organization, auditing subinventory- versus cost-group-based account setup, and feeding downstream posting engines. A representative query joining the view to item and organization masters follows:

• Reconcile account assignments for an organization:
  SELECT organization_id, subinventory_code, cost_group_id, inventory_item_id, material_account, material_overhead_account FROM ax_mtl_category_accounts_v1 WHERE organization_id = :org_id;
• Locate assignments for a specific item:
  SELECT * FROM ax_mtl_category_accounts_v1 WHERE inventory_item_id = :item_id;
• Audit cost-group-based assignments only:
  SELECT cost_group_id, material_account, overhead_account FROM ax_mtl_category_accounts_v1 WHERE cost_group_id IS NOT NULL;

Because the view restricts to the ACCOUNTING category set and joins item categories, results are one row per organization/item/category/subinventory-or-cost-group combination. Absence of rows generally indicates the item is not assigned to the Accounting category set, or that the view is not implemented in the instance.