Search Results storage_class




Overview
Explore in AI Chat

Overview

APPS.IC_STOR_CLS_VW is a backward-compatibility view in Oracle E-Business Suite, owned by the APPS schema and validated in both release 12.1.1 and 12.2.2. It belongs to the GMI (Process Manufacturing Inventory) product family. The view exposes legacy storage class definitions in a format compatible with earlier releases of Oracle Process Manufacturing, allowing historical forms, concurrent programs, reports, and custom extensions to continue referencing storage class data after the underlying data model migrated to Oracle Inventory's category framework.

Storage classes in GMI represent groupings of inventory items by physical storage characteristics such as temperature requirements, hazard classification, or handling restrictions. The view preserves the pre-migration column layout so that legacy code paths do not require modification. Because Oracle EBS 12.2.2 retains the same Online Patching architecture and dual file system, database objects such as this view are compiled at the edition level; APPS.IC_STOR_CLS_VW should therefore be treated as a read-only reporting object rather than a maintenance target.

Underlying Base Objects

IC_STOR_CLS_VW is defined over a UNION of two SELECT statements that join Oracle Inventory category views with a GMI control table. The documented base objects are:

The first branch joins MTL_CATEGORIES_V, MTL_CATEGORY_SETS and GMI_CATEGORY_SETS, filtering for category sets whose VALIDATE_FLAG is not 'Y' and where the concatenated segment equals its uppercase form. The second branch extends the same logic by including MTL_CATEGORY_SET_VALID_CATS, ensuring storage classes with validated category set definitions are also returned. Both branches apply the same column projection and the same eight-character substring on CATEGORY_CONCAT_SEGS.

Key Columns

  • Storage class code — the first column is SUBSTRB(C.CATEGORY_CONCAT_SEGS, 1, 8), truncating the concatenated category segment to the legacy eight-character storage class identifier.
  • CATEGORY_ID — the surrogate key of the underlying MTL_CATEGORIES row.
  • Description — SUBSTRB(C.DESCRIPTION, 1, 70), preserving the original 70-character description length.
  • Audit columns — CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.
  • Disable flag — DECODE(C.DISABLE_DATE, NULL, 0, 1) converts the disable date into the legacy 0/1 enable indicator.
  • ATTRIBUTE1 through ATTRIBUTE15 plus ATTRIBUTE_CATEGORY — carried through from MTL_CATEGORIES_V for descriptive flexfield support.
  • Placeholder columns — literal zero, TO_NUMBER(NULL), and several TO_CHAR(NULL) positions preserve the legacy positional signature without populating values.

Common Use Cases and Queries

Because the view is intended for backward compatibility, typical usage involves legacy reports, conversion routines, and interfaces that must resolve GMI storage class codes. A representative query listing all enabled storage classes follows:

  • SELECT storage_class_code, description FROM apps.ic_stor_cls_vw WHERE disable_flag = 0;
  • SELECT category_id, storage_class_code FROM apps.ic_stor_cls_vw ORDER BY storage_class_code;
  • SELECT COUNT(*) FROM apps.ic_stor_cls_vw; — quick validation that category set linkages remain intact after upgrade or patch application.

Consultants migrating from legacy OPM versions should use the view to reconcile storage class definitions against MTL_CATEGORY_SETS and GMI_CATEGORY_SETS. Any discrepancy in row counts between the view and the filtered category set query typically indicates an orphaned or invalid category set record requiring investigation.