Search Results ic_plnt_inv_u1




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.

  • INDEX: GMI.IC_PLNT_INV_U1 12.2.2

    owner:GMI,  object_type:INDEX,  object_name:IC_PLNT_INV_U1,  status:VALID, 

  • INDEX: GMI.IC_PLNT_INV_U1 12.1.1

    owner:GMI,  object_type:INDEX,  object_name:IC_PLNT_INV_U1,  status:VALID, 

  • Table: IC_PLNT_INV 12.1.1

    owner:GMI,  object_type:TABLE,  fnd_design_data:GMI.IC_PLNT_INV,  object_name:IC_PLNT_INV,  status:VALID,  product: GMI - Process Manufacturing Inventory ,  description: Production rules, by item and plant. These rules are used by MRP and supply defaults for Production Batch creation. ,  implementation_dba_data: GMI.IC_PLNT_INV , 

  • Table: IC_PLNT_INV 12.2.2

    owner:GMI,  object_type:TABLE,  fnd_design_data:GMI.IC_PLNT_INV,  object_name:IC_PLNT_INV,  status:VALID,  product: GMI - Process Manufacturing Inventory ,  description: Production rules, by item and plant. These rules are used by MRP and supply defaults for Production Batch creation. ,  implementation_dba_data: GMI.IC_PLNT_INV , 

  • 12.1.1 DBA Data 12.1.1

  • 12.2.2 DBA Data 12.2.2

  • TABLE: GMI.IC_PLNT_INV 12.2.2

    owner:GMI,  object_type:TABLE,  fnd_design_data:GMI.IC_PLNT_INV,  object_name:IC_PLNT_INV,  status:VALID, 

  • TABLE: GMI.IC_PLNT_INV 12.1.1

    owner:GMI,  object_type:TABLE,  fnd_design_data:GMI.IC_PLNT_INV,  object_name:IC_PLNT_INV,  status:VALID, 

  • eTRM - GMI Tables and Views 12.2.2

    description: Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow. , 

  • eTRM - GMI Tables and Views 12.1.1

    description: Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow. , 

  • eTRM - GMI Tables and Views 12.1.1

    description: Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow. , 

  • eTRM - GMI Tables and Views 12.2.2

    description: Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow. ,