Results for “fte_lane_commodities”

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

Overview

FTE_LANE_COMMODITIES is a Transportation Execution (FTE) module table in Oracle E-Business Suite, owned by the FTE schema. Its documented purpose is to store commodity information for each lane, enabling the Transportation Execution and Global Trade Management (formerly ETRM) functionality to associate one or more commodity classifications with a given transportation lane. This association influences rating, compliance screening, and restricted-party or license determination logic applied at the lane level in 12.1.1 and 12.2.2.

Under a heuristic Data Vault classification mined from the foreign-key structure, FTE_LANE_COMMODITIES is best described as a link table. It does not represent an independent business entity; instead it resolves a many-to-many-style relationship between lanes and commodity category definitions. Modeling it as a link aligns with its role as an associative intersection carrying a small set of descriptive attributes (such as BASIS) rather than serving as a standalone hub or a fully-versioned satellite. This classification is a modeling suggestion derived from the FK topology rather than an Oracle-declared construct.

Key Information Stored

The table contains nine documented columns. The most important are:

• LANE_COMMODITY_ID — the surrogate primary key, defined by the constraint FTE_LANE_COMMODITIES_PK. This value uniquely identifies each lane-to-commodity association and is system-generated.
• LANE_ID — the foreign key referencing FTE_LANES. This is the business-meaningful anchor pointing to the specific transportation lane being qualified.
• COMMODITY_CATG_ID — the foreign key referencing MTL_CATEGORIES_B, identifying the commodity category (commodity classification) associated with the lane. Together, LANE_ID and COMMODITY_CATG_ID form the natural business-key candidate for a unique index, although only the surrogate PK is documented.
• BASIS — a descriptive attribute qualifying how the commodity association applies (for example, the basis on which the lane-commodity relationship is evaluated), used in downstream rating or compliance logic.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns capturing who created and last modified the record and when, plus the login context of the last update.

Common Use Cases and Queries

Typical usage includes identifying which commodities are valid for a lane during shipment planning, evaluating trade-compliance screening by lane and commodity, and reporting lane coverage by classification. The most common query pattern joins back to FTE_LANES and MTL_CATEGORIES_B to retrieve human-readable descriptions:

• Lane commodity listing: SELECT lc.LANE_COMMODITY_ID, l.lane_name, mc.segment1, lc.BASIS FROM FTE.FTE_LANE_COMMODITIES lc, FTE.FTE_LANES l, MTL_CATEGORIES_B mc WHERE lc.LANE_ID = l.LANE_ID AND lc.COMMODITY_CATG_ID = mc.CATEGORY_ID.
• Commodities for a specific lane: filter on LANE_ID to drive pickup or delivery validation.
• Lanes for a specific commodity: filter on COMMODITY_CATG_ID to support compliance or license determination.
• Audit reporting: filter on CREATION_DATE or LAST_UPDATE_DATE ranges to track recent configuration changes.

Related Objects

• FTE_LANES — joined via FTE_LANE_COMMODITIES.LANE_ID = FTE_LANES.LANE_ID; the parent lane definition.
• MTL_CATEGORIES_B — joined via FTE_LANE_COMMODITIES.COMMODITY_CATG_ID = MTL_CATEGORIES_B.CATEGORY_ID; the commodity category master.
• FTE_LANE_COMMODITIES_PK — the primary key constraint enforcing uniqueness on LANE_COMMODITY_ID.
• MTL_CATEGORIES_TL — the translated name table commonly joined to MTL_CATEGORIES_B for reporting commodity descriptions.
• FTE lane rating and compliance engine objects — dependent logic that consults lane-commodity associations during rating and screening.

Together these relationships make FTE_LANE_COMMODITIES a compact but essential intersection linking transportation lanes to the commodity classifications that govern trade and rating behavior.