Results for “compile_items”

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

Overview

MTL_ABC_COMPILE_HEADERS is an Oracle Inventory (INV) table that stores ABC compile header data within Oracle E-Business Suite 12.1.1 and 12.2.2. ABC analysis classifies inventory items into A, B, and C buckets based on usage or value criteria, allowing planners to prioritize cycle counting, physical inventory, and replenishment effort on high-impact items. Each row in this table represents a single ABC compilation request — the defining header record against which the compilation details, assignment groups, and compiled item classifications are organized.

The table sits at the transactional/configuration boundary of the ABC subsystem. A row captures the compilation scope (organization, subinventory, cost type, schedule or forecast designator), the compile status, and execution bookkeeping. From a modeling perspective, the documented foreign-key structure classifies this object heuristically as satellite-leaning: it holds descriptive and state attributes that surround a compilation event identity, anchored by the primary key rather than functioning as a pure junction or hub. This classification is a modeling suggestion drawn from the FK topology, not a prescriptive rule.

Key Information Stored

The table is documented with 44 columns in INV. The following are the most operationally significant:

• COMPILE_ID — the surrogate primary key (MTL_ABC_COMPILE_HEADERS_PK), and the value propagated to child tables as the parent reference.
• COMPILE_NAME — the user-facing business identifier; together with ORGANIZATION_ID it forms the documented unique index MTL_ABC_COMPILE_HEADERS_U2, making it the principal business-key candidate alongside the surrogate COMPILE_ID (also enforced uniquely in MTL_ABC_COMPILE_HEADERS_U1).
• ORGANIZATION_ID — the inventory organization the compile applies to; the FK to MTL_PARAMETERS.
• COMPILE_TYPE and COMPILE_STATUS — the classification basis (for example usage- or value-based) and the lifecycle state of the run.
• SECONDARY_INVENTORY — narrows the compilation scope to a subinventory (FK to MTL_SECONDARY_INVENTORIES).
• ITEM_SCOPE_CODE — defines whether all items or a restricted subset are evaluated.
• COST_TYPE and COST_CODE — drive cost-based ranking (FK to CST_COST_TYPES).
• CUMULATIVE_QUANTITY and CUMULATIVE_VALUE — the accumulated thresholds used to derive A/B/C breakpoints.
• SCHEDULE_TYPE and SCHEDULE_DESIGNATOR — the schedule scope, with the designator FK referencing MRP_SCHEDULE_DESIGNATORS.
• MRP_PLAN_NAME and MRP_FORECAST_NAME — planning and forecast scope; MRP_FORECAST_NAME references MRP_FORECAST_DESIGNATORS, directly relevant to searches for forecast designator usage in ABC compiles.
• START_DATE and CUTOFF_DATE — the demand or activity window over which usage is measured.
• COMPILE_DATE — the effective date of the compilation.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program bookkeeping identifying the submission that produced the row.

A standard attribute flexfield (ATTRIBUTE_CATEGORY through ATTRIBUTE15) provides extensibility, while CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY supply audit context.

Common Use Cases and Queries

Primary uses include determining when an organization was last compiled, auditing the scope parameters of a compilation, and linking a compilation to its item-level results and assignment groups.

SELECT compile_id, compile_name, organization_id, compile_status,
       compile_type, compile_date, cutoff_date, mrp_forecast_name
  FROM   mtl_abc_compile_headers
 WHERE  organization_id = :org_id
 ORDER  BY compile_date DESC;

Locating every ABC compile that referenced a specific forecast designator is a frequent analysis:

SELECT h.compile_id, h.compile_name, h.organization_id,
       h.mrp_forecast_name, h.compile_status
  FROM   mtl_abc_compile_headers h,
         mrp_forecast_designators d
 WHERE  h.mrp_forecast_name = d.forecast_designator
   AND  h.organization_id    = d.organization_id;

Identifying the latest successful run per organization supports reporting on current ABC assignments:

SELECT organization_id, MAX(compile_date) last_compile
  FROM   mtl_abc_compile_headers
 WHERE  compile_status = 'COMPLETED'
 GROUP  BY organization_id;

Typical report outputs include a compile history register, scope-audit listings showing cost type, schedule, and forecast inputs, and cross-references from compiled results back to their originating header.

Related Objects

The following objects are the most significant dependents and references, per the documented FK structure:

• MTL_ABC_COMPILES — the child table holding item-level results, joined via COMPILE_ID.
• MTL_ABC_ASSIGNMENT_GROUPS — assignment group definitions linked by COMPILE_ID.
• MRP_FORECAST_DESIGNATORS — referenced through MRP_FORECAST_NAME and ORGANIZATION_ID; defines the forecast scope.
• MRP_SCHEDULE_DESIGNATORS — referenced through SCHEDULE_DESIGNATOR and ORGANIZATION_ID; defines the schedule scope.
• MFG_ORGANIZATIONS / MTL_PARAMETERS — the organization definition referenced by ORGANIZATION_ID.
• MTL_SECONDARY_INVENTORIES — referenced through SECONDARY_INVENTORY and ORGANIZATION_ID.
• CST_COST_TYPES — referenced through COST_TYPE for cost-based rankings.
• MRP_PLANS — referenced through ORGANIZATION_ID and MRP_PLAN_NAME for plan-based scope.
• MTL_ABC_COMPILE_HEADERS_EFC — the EFC (enterprise/financial consolidation) companion view for this table.

Together these relationships position MTL_ABC_COMPILE_HEADERS as the control record through which every ABC classification run in Oracle Inventory is defined, executed, and audited.