Search Results ic_rank_mst_pk

Overview

The IC_RANK_MST table is a master data table within the Oracle E-Business Suite Process Manufacturing Inventory (GMI) module. It serves a critical role in the cycle counting functionality by defining and storing rank information. This rank data is a fundamental component of the system's logic for automatically generating and scheduling cycle counts for inventory items. By assigning ranks based on criteria such as warehouse and ABC classification, the table enables a structured, priority-driven approach to inventory accuracy audits, which is essential for maintaining precise stock records in a process manufacturing environment.

Key Information Stored

The table's structure centers on defining a unique rank for specific inventory groupings. Its primary key, consisting of WHSE_CODE and ABC_CODE, indicates that a rank is uniquely defined per warehouse and ABC classification code. While the full column list is not detailed in the provided metadata, the foreign key relationships imply the presence of several key columns. The WHSE_CODE column links to the IC_WHSE_MST (warehouse master) table. The ABC_CODE represents the item's ABC classification (e.g., A, B, C). A TEXT_CODE column exists to link descriptive text from the IC_TEXT_HDR table. The core of the table likely includes a RANK or similar column that holds the numerical or alphanumeric priority value used to schedule counts.

Common Use Cases and Queries

The primary use case is the automated generation of cycle count schedules. The system uses the rank defined in IC_RANK_MST, often in conjunction with item value or transaction frequency, to determine how frequently an item should be counted. Common reporting and validation queries involve joining this table to warehouse and item data. For example, to list all defined ranks by warehouse, a query might be: SELECT r.whse_code, w.whse_desc, r.abc_code, r.rank FROM gmi.ic_rank_mst r, gmi.ic_whse_mst w WHERE r.whse_code = w.whse_code ORDER BY 1, 3;. Another critical query validates that items in the IC_WHSE_INV table have a corresponding rank definition: SELECT i.* FROM gmi.ic_whse_inv i WHERE NOT EXISTS (SELECT 1 FROM gmi.ic_rank_mst r WHERE r.whse_code = i.whse_code AND r.abc_code = i.whse_abccode);.

Related Objects

IC_RANK_MST is centrally connected to several key inventory tables. It has a direct foreign key relationship to IC_WHSE_MST via WHSE_CODE, ensuring rank definitions are tied to valid warehouses. It is referenced by the IC_WHSE_INV table (which stores inventory balances) through that table's composite foreign key on WHSE_CODE and WHSE_ABCCODE, linking each inventoried item to its applicable rank. The relationship to IC_TEXT_HDR via TEXT_CODE allows for descriptive notes on the rank definition. The primary key constraint IC_RANK_MST_PK enforces the uniqueness of the warehouse and ABC code combination.