Search Results ic_allc_cls_vw




Overview
Explore in AI Chat

Overview

IC_ALLC_CLS_VW is a backward-compatibility view owned by the APPS schema in Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. It belongs to the GMI - Process Manufacturing Inventory product family and exposes allocation class definitions that were originally modeled before Oracle Process Manufacturing (OPM) inventory was integrated with the Oracle Inventory category framework. The view is registered as VALID in the ETRM metadata and is referenced whenever legacy code, concurrent programs, or custom reports search on the term "alloc_class".

Its role is primarily that of a compatibility shim: it translates the modern Oracle Inventory category model (MTL_CATEGORIES, MTL_CATEGORY_SETS, MTL_CATEGORY_SET_VALID_CATS) into the flat, wide column layout expected by earlier releases of OPM Process Manufacturing Inventory. Any interface or report that still selects ALLOC_CLASS, ALLOC_CATEGORY_ID, or ALLOC_DESC continues to function without code changes.

Underlying Base Objects

The view definition joins four documented base objects. GMI_CATEGORY_SETS is the OPM-side classification table (referenced through a synonym) and is filtered on OPM_CLASS = 'ALLOC_CLASS', which is the discriminator identifying allocation classes as opposed to other OPM category classes. MTL_CATEGORY_SETS supplies the category set headers, joined on CATEGORY_SET_ID. MTL_CATEGORIES_V is the category value view, joined through STRUCTURE_ID, providing the concatenated segment string, category ID, and description. MTL_CATEGORY_SET_VALID_CATS is used only in the second half of a UNION ALL, restricting valid categories when the category set has VALIDATE_FLAG = 'Y'.

The view text is a UNION of two branches: the first returns categories for category sets where VALIDATE_FLAG <> 'Y', and the second returns categories validated against MTL_CATEGORY_SET_VALID_CATS where VALIDATE_FLAG = 'Y'. Both branches impose CATEGORY_CONCAT_SEGS = UPPER(SUBSTRB(CATEGORY_CONCAT_SEGS, 1, 8)), so only allocation class codes that are uppercase and exactly eight characters or fewer are surfaced.

Key Columns

  • ALLOC_CLASS — The eight-character allocation class code, derived from SUBSTRB(CATEGORY_CONCAT_SEGS, 1, 8).
  • ALLOC_CATEGORY_ID — The underlying CATEGORY_ID, used as the foreign key to category-based lookups.
  • ALLOC_DESC — The class description, truncated to 70 bytes from MTL_CATEGORIES_V.DESCRIPTION.
  • DELETE_MARK — Derived by DECODE(DISABLE_DATE, NULL, 0, 1); 0 indicates an active allocation class, 1 an inactive one.
  • TRANS_CNT and TEXT_CODE — Legacy placeholders returned as literal 0 and a NULL number respectively, retained for column-count compatibility with older OPM interfaces.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns passed through from MTL_CATEGORIES_V.

Common Use Cases and Queries

The view is typically queried to populate an allocation class list of values, to validate an allocation class entered in a conversion or inventory transaction screen, or to join allocation classes to inventory items for reporting. A representative query for active allocation classes is:

  • SELECT alloc_class, alloc_category_id, alloc_desc FROM apps.ic_allc_cls_vw WHERE delete_mark = 0 ORDER BY alloc_class;
  • SELECT alloc_class, alloc_desc FROM apps.ic_allc_cls_vw WHERE UPPER(alloc_class) LIKE :p_search || '%';
  • SELECT i.inventory_item_id, v.alloc_class FROM apps.ic_allc_cls_vw v, apps.mtl_item_categories i WHERE v.alloc_category_id = i.category_id;

Because the view filters on eight-character uppercase codes, customizations should avoid passing lowercase search strings without an UPPER() conversion. Direct DML against the view is not supported; allocation classes must be maintained through the OPM class maintenance forms that update GMI_CATEGORY_SETS and the underlying Oracle Inventory category tables.