Results for “ic_plnt_inv”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IC_PLNT_INV is a GMI (Process Manufacturing Inventory) base table owned by the GMI schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores production rules defined at the item and plant (organization) level. These rules drive MRP planning behavior and provide the supply defaults consumed during Production Batch creation. In practical terms, the table answers the question: for a given item in a given plant, how should the system plan, size, and schedule replenishment or production?
The documented ETRM metadata assigns IC_PLNT_INV a heuristic Data Vault classification of link. This classification is mined from the foreign key structure and should be treated as a modeling suggestion rather than a definitive declaration. The link interpretation is consistent with the table's role: its unique business key is the combination of ITEM_ID and ORGN_CODE, joining the item dimension to the organization dimension, with the remaining columns carrying rule attributes.
The table is registered as VALID and contains 52 documented columns, most of which are reserved for descriptive flexfield storage (ATTRIBUTE1 through ATTRIBUTE30 plus ATTRIBUTE_CATEGORY).
Key Information Stored
The table uses two documented unique indexes. IC_PLNT_INV_PK is the surrogate primary key on PLNTINV_ID, a system-generated identifier. IC_PLNT_INV_U1 is the business-key candidate on the natural combination of ITEM_ID and ORGN_CODE, which enforces one production rule set per item per plant.
The most significant columns fall into three groups:
- Identity and context: PLNTINV_ID (surrogate PK), ITEM_ID (the planned item), ORGN_CODE (the plant or organization code).
- Planning and sizing rules: MIN_QTY, MAX_QTY, and STD_QTY define minimum, maximum, and standard quantities used for batch sizing and supply defaults. RULE_TYPE identifies the production rule category applied to the item-plant combination.
- Lead time and time fence rules: FIXED_LEADTIME, VARIABLE_LEADTIME, RESCHEDULE_PERIOD, INNER_TIMEFENCE, OUTER_TIMEFENCE, and CONTIGUITY_IND govern scheduling behavior, reschedule windows, and time-fence enforcement during MRP planning.
- Administrative and audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, TRANS_CNT, and DELETE_MARK. TEXT_CODE links to the text header for free-form comments. The ATTRIBUTE1–ATTRIBUTE30 columns plus ATTRIBUTE_CATEGORY support flexfield extension.
Common Use Cases and Queries
Typical use cases include validating that production rules exist before batch creation, auditing lead time settings across plants, and feeding planning reports with rule values. A standard lookup retrieves the rule for a single item and plant:
SELECT * FROM gmi.ic_plnt_inv WHERE item_id = :p_item AND orgn_code = :p_orgn AND delete_mark = 0;
For cross-plant analysis, join to the item master to resolve identifiers and descriptions, then aggregate by ORGN_CODE to compare STD_QTY or lead time settings. A typical pattern joins IC_PLNT_INV to IC_ITEM_MST on ITEM_ID to obtain the item number, and to SY_ORGN_MST on ORGN_CODE to obtain the plant description. Reporting use cases include exception reports for items with missing or expired reschedule periods, and time-fence compliance reports for items where INNER_TIMEFENCE is populated.
Because DELETE_MARK is a documented soft-delete indicator, application-oriented queries should filter on it to exclude logically deleted rows. Reporting queries should also account for the large number of flexfield attributes by selecting only the needed columns.
Related Objects
The documented foreign keys define the core join paths:
- IC_ITEM_MST — joined on IC_PLNT_INV.ITEM_ID = IC_ITEM_MST.ITEM_ID; the primary item master reference.
- IC_ITEM_MST_B — joined on IC_PLNT_INV.ITEM_ID = IC_ITEM_MST_B.ITEM_ID; the companion item master table.
- SY_ORGN_MST — joined on IC_PLNT_INV.ORGN_CODE = SY_ORGN_MST.ORGN_CODE; provides the plant or organization definition.
- SY_ORGN_MST_B — joined on IC_PLNT_INV.ORGN_CODE = SY_ORGN_MST_B.ORGN_CODE; the companion organization table.
- IC_TEXT_HDR — joined on IC_PLNT_INV.TEXT_CODE = IC_TEXT_HDR.TEXT_CODE; supplies free-form text associated with the rule set.
In addition to these FK relationships, the table interacts functionally with GMI production batch creation logic and MRP planning processes, which read the rule values to derive supply defaults and scheduling parameters.
-
Production rules, by item and plant. These rules are used by MRP and supply defaults for Production Batch creation.
-
Production rules, by item and plant. These rules are used by MRP and supply defaults for Production Batch creation.
-
SYNONYM: APPS.IC_PLNT_INV 12.2.2
-
SYNONYM: APPS.IC_PLNT_INV 12.1.1
-
TABLE: GMI.IC_PLNT_INV 12.1.1
-
TABLE: GMI.IC_PLNT_INV 12.2.2
-
VIEW: GMI.IC_PLNT_INV# 12.2.2
-
View: PMIFV_PROD_EFFI_V 12.2.2
Batch Efficiency
APPS.PMIFV_PROD_EFFI_V·↳ FM_FORM_MST_B·↳ GME_BATCH_HEADER·↳ GME_MATERIAL_DETAILS·Explore PMI module →
-
View: PMIFV_PROD_EFFI_V 12.1.1
Batch Efficiency
APPS.PMIFV_PROD_EFFI_V·↳ FM_FORM_MST_B·↳ GME_BATCH_HEADER·↳ GME_MATERIAL_DETAILS·Explore PMI module →
-
12.2.2 DBA Data 12.2.2
-
VIEW: GMI.IC_PLNT_INV# 12.2.2
-
VIEW: APPS.PMIFV_PROD_EFFI_V 12.2.2
-
VIEW: APPS.PMIFV_PROD_EFFI_V 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
VIEW: APPS.PMIFV_PROD_EFFI_V 12.1.1
-
VIEW: APPS.PMIFV_PROD_EFFI_V 12.2.2
-
Table: SY_ORGN_MST 12.1.1
Organization code master.
Not implemented in this database·Explore GMA module →
-
Table: SY_ORGN_MST 12.2.2
Organization code master.
Not implemented in this database·Explore GMA module →
-
View: PMI_EDW_BTCH_DTL_F_FCV 12.2.2
Not implemented in this database·Explore PMI module →
-
Table: IC_ITEM_MST 12.2.2
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
Not implemented in this database·Explore GMI module →
-
View: PMI_EDW_BTCH_DTL_F_FCV 12.1.1
Not implemented in this database·Explore PMI module →
-
Table: IC_ITEM_MST 12.1.1
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
Not implemented in this database·Explore GMI module →
-
OPM Source View for Job Detail Fact. This Source View is based on OPM Batch and Material Details. The Source view Included the Products and Co-Products data alson with Material inputs , By product Yields etc
APPS.OPI_EDW_OPM_JOB_DETAIL_FCV·↳ EDW_CURRENCY·↳ EDW_ITEMS_PKG·↳ EDW_LOCAL_INSTANCE·Explore OPI module →
-
OPM Source View for Job Detail Fact. This Source View is based on OPM Batch and Material Details. The Source view Included the Products and Co-Products data alson with Material inputs , By product Yields etc
Not implemented in this database·Explore OPI module →
-
eTRM - GMI Tables and Views 12.1.1
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
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 - PMI Tables and Views 12.2.2
-
eTRM - OPI Tables and Views 12.1.1
-
eTRM - PMI Tables and Views 12.1.1
-
eTRM - GMI Tables and Views 12.2.2
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.