Search Results ic_plnt_inv




Overview
Explore in AI Chat

Overview

The IC_PLNT_INV table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Inventory (GMI) module. It serves as the central repository for production rules and inventory control parameters defined at the intersection of an item and a plant (organization). This table is fundamental for managing manufacturing operations in process industries, as it stores the rules that govern material requirements planning (MRP) and provides critical supply defaults used during the creation of production batches. Its configuration directly influences planning accuracy and production execution workflows.

Key Information Stored

The table's primary key is the unique identifier PLNTINV_ID. However, its logical key, enforced by a unique constraint (IC_PLNT_INV_U1), is the combination of ITEM_ID and ORGN_CODE, ensuring a single set of production rules per item per plant. Key columns include ITEM_ID, which links to the item master, and ORGN_CODE, which links to the organization master. Other significant fields typically include parameters for lot control, shelf life, planning methods, yield percentages, and default supply sources. The TEXT_CODE column provides a foreign key link to descriptive text blocks in the IC_TEXT_HDR table, allowing for detailed rule annotations.

Common Use Cases and Queries

A primary use case is the retrieval of production rules for MRP planning or batch creation interfaces. For example, when launching a new production batch, the system queries this table to default the supply type, sourcing organization, or other control parameters. Common reporting needs include listing all configured items for a specific plant or identifying items missing plant-level inventory rules. A sample query to fetch active item rules for a plant would be:

  • SELECT i.item_no, p.* FROM ic_plnt_inv p, ic_item_mst_b i WHERE p.item_id = i.item_id AND p.orgn_code = '&PLANT_CODE';

Data in this table is often maintained via the "Item Plant Inventory" form within the GMI application, not via direct SQL manipulation.

Related Objects

IC_PLNT_INV has integral relationships with several master and transactional tables, as documented by its foreign keys. The key relationships are:

  • IC_ITEM_MST / IC_ITEM_MST_B: Joined via ITEM_ID. This links the plant-specific rules to the global item definition.
  • SY_ORGN_MST / SY_ORGN_MST_B: Joined via ORGN_CODE. This links the rules to the organizational structure (plant).
  • IC_TEXT_HDR: Joined via TEXT_CODE. This provides optional extended text descriptions for the production rules.

Given its role, this table is also heavily referenced by MRP engine programs and batch creation APIs within the Process Manufacturing suite.