Results for “commodity_code”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IC_COMD_CDS is the Commodity Codes table in the Oracle E-Business Suite Process Manufacturing Inventory (GMI) module. It resides in the GMI schema and holds the master list of commodity codes consumed by the Intrastat reporting facility. Intrastat is the statistical declaration system used within the European Union to track the movement of goods between member states, and each declared line must reference a valid commodity code (the Combined Nomenclature / CN code). IC_COMD_CDS therefore acts as the reference or lookup source that classifies inventoried items for statutory trade reporting.

Within the GMI inventory model, the table plays the role of a small, slowly changing reference entity. The mined relationship data classifies it heuristically as hub-leaning under a Data Vault modeling convention. This suggests that, if the schema were refactored along Data Vault lines, COMMODITY_CODE would function as a hub business key, with descriptive attributes (such as COMMODITY_DESC) carried in an associated satellite, and the TEXT_CODE pointer resolved as a link to the text header hub. This is a modeling suggestion only; in the delivered EBS schema the table is a conventional normalized master table.

Key Information Stored

The table is documented with ten physical columns. The following are the most significant:

  • COMMODITY_CODE — The primary key of the table (constraint IC_COMD_CDS_PK) and the sole unique index / business-key candidate. It carries the commodity classification value assigned to an item.
  • COMMODITY_DESC — The descriptive name or description associated with the commodity code, used for display and reporting.
  • TEXT_CODE — A foreign key to IC_TEXT_HDR, allowing extended or multilingual text to be attached to a commodity code record.
  • TRANS_CNT — The standard EBS transaction counter column used for optimistic locking and concurrency control during DML.
  • DELETE_MARK — The soft-delete flag; records are logically inactivated rather than physically removed.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard EBS audit columns recording who created and last modified the row and when.

No surrogate numeric key is documented; the natural business key COMMODITY_CODE serves as the primary key, which is typical for GMI reference tables.

Common Use Cases and Queries

Typical uses center on Intrastat declaration preparation, item classification maintenance, and inventory reporting. A common pattern is to resolve the commodity code attached to an item:

  • Item-to-commodity lookup: SELECT i.ITEM_NO, i.COMMODITY_CODE, c.COMMODITY_DESC FROM IC_ITEM_MST i, IC_COMD_CDS c WHERE i.COMMODITY_CODE = c.COMMODITY_CODE;
  • Unclassified item exception report: list items where COMMODITY_CODE is null or does not resolve to an active code (DELETE_MARK = 0) — used to clean data before Intrastat submission.
  • Reference validation: join to IC_TEXT_HDR via TEXT_CODE to retrieve extended descriptions for statutory or customs documentation.
  • Intrastat declaration basis: aggregate shipped quantities and values by COMMODITY_CODE across the declaration period.

Because the table is small and stable, it is frequently cached in reports and extracts rather than queried transactionally.

Related Objects

  • IC_ITEM_MST — Item master table. References IC_COMD_CDS via IC_ITEM_MST.COMMODITY_CODE.
  • IC_ITEM_MST_B — Item master extension table. Also references IC_COMD_CDS via COMMODITY_CODE.
  • IC_TEXT_HDR — Text header table, referenced by IC_COMD_CDS.TEXT_CODE for extended commodity descriptions.
  • IC_COMD_CDS_PK — The primary key constraint / unique index on COMMODITY_CODE that enforces uniqueness of the business key.

Together these relationships confirm IC_COMD_CDS as a central reference point for item-level commodity classification feeding the Intrastat module.