Search Results ic_frgt_cls




Overview
Explore in AI Chat

Overview

The IC_FRGT_CLS table is a foundational master data table within the GMI (Process Manufacturing Inventory) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for defining freight class codes, which are standardized classifications used to categorize items for shipping and freight cost calculations. These classifications are critical for logistics, transportation planning, and cost accounting within Oracle Process Manufacturing (OPM). The table's primary role is to provide a validated list of freight classes that can be consistently referenced by other transactional and master data entities throughout the inventory and shipping processes, ensuring data integrity and standardized freight handling.

Key Information Stored

Based on the provided metadata, the table's structure centers on a primary key column that uniquely identifies each freight class. While the full column list is not detailed, the foreign key relationships indicate the core data elements. The primary column is ICFRT_CLASS, which holds the unique freight class code. This code is referenced by the TEXT_CODE column in the IC_TEXT_HDR table, suggesting the table may also store or link to descriptive text for each class. The table's design enforces referential integrity, ensuring that freight classes assigned to items or warehouse inventory are valid and predefined.

Common Use Cases and Queries

The primary use case is the assignment of a freight class to an item master record (IC_ITEM_MST) and to specific inventory records (IC_WHSE_INV). This assignment directly influences freight cost engines and shipping documentation. Common queries involve listing all valid freight classes for setup or validation, and identifying items associated with a specific class for logistics analysis. A typical reporting query would join IC_FRGT_CLS to the item master.

  • Sample Query to List All Defined Freight Classes:
    SELECT icfrt_class FROM ic_frgt_cls ORDER BY 1;
  • Sample Query to Report Items by Freight Class:
    SELECT i.item_no, i.item_desc, f.icfrt_class FROM ic_item_mst i, ic_frgt_cls f WHERE i.frt_class = f.icfrt_class(+);

Related Objects

The IC_FRGT_CLS table is integrated into the OPM data model through key foreign key relationships, as documented. It is a parent table to several critical entities:

  • IC_ITEM_MST (Item Master): The FRT_CLASS column in this table references IC_FRGT_CLS, assigning a default freight class to each inventoried item.
  • IC_WHSE_INV (Warehouse Inventory): The FRT_CLASS column at this level may allow for warehouse-specific freight class overrides for an item, also referencing IC_FRGT_CLS.
  • IC_TEXT_HDR: Linked via the TEXT_CODE, this relationship likely allows for storing extensive descriptive text or notes for each freight class definition.

These relationships underscore that IC_FRGT_CLS is a controlled code lookup essential for maintaining consistent freight data across the item lifecycle, from master data creation to inventory tracking.