Search Results ic_item_cpg_pk




Overview
Explore in AI Chat

Overview

IC_ITEM_CPG is a standalone table owned by the GMI schema within the Oracle E-Business Suite Process Manufacturing Inventory module. Its documented purpose is to hold item information that is specific to a CPG (Consumer Packaged Goods) installation, meaning the table stores attributes that apply only when Process Manufacturing Inventory is deployed in a CPG-oriented configuration. The table is valid and present in both Oracle EBS 12.1.1 and 12.2.2 environments, with the documented physical schema drawn from ETRM 12.2.2 reflecting eight columns and a single unique index, IC_ITEM_CPG_PK, defined on ITEM_ID.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as standalone under a Data Vault classification scheme. As a modeling suggestion, this indicates that IC_ITEM_CPG is neither a hub, link, nor satellite in the strict Data Vault sense, because it carries no documented foreign key relationships to other tables. It functions as an extension table holding descriptive or operational attributes keyed directly to an item identifier, with ITEM_ID serving as the documented primary key column. The absence of FK metadata suggests the table is queried independently or joined to item master data through application-level logic rather than enforced referential constraints.

Key Information Stored

The documented column set contains eight columns. The most operationally significant are:

  • ITEM_ID — The primary key column and the sole component of the IC_ITEM_CPG_PK unique index. It is the documented surrogate/business-key candidate that identifies the item to which the CPG-specific attributes apply. Because this is the only unique index documented, ITEM_ID is the single business-key candidate for the row.
  • IC_MATR_DAYS — A CPG-specific numeric attribute recording a maturation or material-related duration in days. This column drives shelf-life and aging calculations specific to CPG manufacturing processes.
  • IC_HOLD_DAYS — A CPG-specific numeric attribute recording a hold period in days, governing how long an item remains in a hold status before release within CPG workflows.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard Oracle EBS WHO columns providing audit lineage for row creation and modification. These are essential for tracking data provenance and are consistent with the standard EBS audit-column convention used across GMI tables.

No other attribute columns are documented beyond these eight, indicating the table is intentionally narrow and specialized.

Common Use Cases and Queries

Typical uses center on retrieving CPG-specific durations for an item, typically joined logically to the item master via ITEM_ID. A representative query retrieves the maturation and hold parameters for a specific item:

  • SELECT item_id, ic_matr_days, ic_hold_days FROM gmi.ic_item_cpg WHERE item_id = :item_id;
  • Reporting queries often list all items with configured CPG durations: SELECT item_id, ic_matr_days, ic_hold_days FROM gmi.ic_item_cpg;
  • Audit-oriented queries examine WHO columns: SELECT item_id, last_updated_by, last_update_date FROM gmi.ic_item_cpg WHERE last_update_date > :cutoff;

Because the table is standalone, reporting typically joins to the item master (for example, IC_ITEM_MST) on ITEM_ID at the application or view layer. Data extraction for CPG shelf-life or hold-period analytics is another common scenario.

Related Objects

The ETRM metadata documents no foreign keys or dependent objects for IC_ITEM_CPG, and the Data Vault classification is standalone. Consequently, related objects are inferred through the shared ITEM_ID key rather than enforced constraints. The most significant are the item master and inventory-related GMI tables that share ITEM_ID, such as IC_ITEM_MST (item master), the IC_ITEM_CPG_PK index itself, and inventory transaction tables keyed to ITEM_ID. Because no FK relationships are documented, joins to these tables must be established through application logic on ITEM_ID rather than database-enforced referential integrity.

  • INDEX: GMI.IC_ITEM_CPG_PK 12.1.1

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

  • Table: IC_ITEM_CPG 12.1.1

    owner:GMI,  object_type:TABLE,  fnd_design_data:GMI.IC_ITEM_CPG,  object_name:IC_ITEM_CPG,  status:VALID,  product: GMI - Process Manufacturing Inventory ,  description: This table contains item information that is specific to a CPG installation. ,  implementation_dba_data: GMI.IC_ITEM_CPG , 

  • Table: IC_ITEM_CPG 12.2.2

    owner:GMI,  object_type:TABLE,  fnd_design_data:GMI.IC_ITEM_CPG,  object_name:IC_ITEM_CPG,  status:VALID,  product: GMI - Process Manufacturing Inventory ,  description: This table contains item information that is specific to a CPG installation. ,  implementation_dba_data: GMI.IC_ITEM_CPG , 

  • TABLE: GMI.IC_ITEM_CPG 12.1.1

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

  • INDEX: GMI.IC_ITEM_CPG_PK 12.2.2

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

  • 12.1.1 DBA Data 12.1.1

  • TABLE: GMI.IC_ITEM_CPG 12.2.2

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

  • 12.2.2 DBA Data 12.2.2

  • 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. ,