Search Results mtl_abc_compile_headers




Overview
Explore in AI Chat

Overview

The MTL_ABC_COMPILE_HEADERS table is a core data object within the Oracle E-Business Suite Inventory (INV) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master header table for ABC (Activity-Based Costing) Compilation processes. An ABC Compilation is a periodic analytical procedure that classifies inventory items into categories—typically A, B, and C—based on predefined criteria such as usage value, transaction volume, or other business metrics. This classification is fundamental for implementing selective inventory control policies. The table stores the control parameters and master definitions for each unique compilation run, acting as the parent record for detailed assignment data stored in related tables.

Key Information Stored

The table's primary key is the COMPILE_ID, a unique system-generated identifier for each compilation. Other critical columns define the scope and rules of the analysis. The ORGANIZATION_ID ties the compilation to a specific inventory organization. Key parameter columns include SCHEDULE_DESIGNATOR (linking to MRP schedules), SECONDARY_INVENTORY (to restrict analysis to a specific subinventory), MRP_FORECAST_NAME, MRP_PLAN_NAME, and COST_TYPE. These columns allow the compilation to be executed against a highly specific dataset, such as items within a particular plan or valued with a specific cost type. Additional columns typically track the compilation's status, creation date, and the user who initiated it, providing a complete audit trail.

Common Use Cases and Queries

The primary use case is generating and reviewing historical ABC classification analyses. Analysts query this table to understand past compilation parameters or to monitor ongoing jobs. A common reporting query retrieves header information for compilations within a specific organization and date range. For technical support, identifying details for a specific compile ID is frequent. Furthermore, the table is central to any data fix or purge activity related to ABC compilations, as operations must start at the header level to maintain referential integrity with child assignment records.

  • Listing recent compilations: SELECT compile_id, creation_date, last_update_date FROM mtl_abc_compile_headers WHERE organization_id = :org_id ORDER BY creation_date DESC;
  • Finding compilations using a specific cost type: SELECT compile_id, cost_type FROM mtl_abc_compile_headers WHERE cost_type = :cost_type_name;

Related Objects

As indicated by its foreign keys, MTL_ABC_COMPILE_HEADERS has strong relationships with several key EBS tables. It references master data tables like MTL_PARAMETERS (organizations), MTL_SECONDARY_INVENTORIES, MRP_SCHEDULE_DESIGNATORS, MRP_FORECAST_DESIGNATORS, MRP_PLANS, and CST_COST_TYPES to validate parameters. Most importantly, it is the direct parent to the MTL_ABC_ASSIGNMENT_GROUPS and MTL_ABC_COMPILES tables. The MTL_ABC_ASSIGNMENT_GROUPS table stores the group definitions (e.g., classification rules and value bands), while MTL_ABC_COMPILES stores the detailed item-level assignment results for each compilation, linked via the COMPILE_ID. Any process or report examining ABC classification results will join from this header table to these child tables.