Search Results org_freight_tl




Overview
Explore in AI Chat

Overview

ORG_FREIGHT_TL is the translatable (TL) child table of the Oracle Inventory freight code definition, owned by the INV schema. It stores the language-specific descriptive attributes for freight codes defined at the organization level, most notably the user-facing DESCRIPTION text. In Oracle E-Business Suite 12.1.1 and 12.2.2, freight codes are used to identify shipping charge arrangements (for example carrier, freight terms, or freight cost types) that can be referenced on purchasing, receiving, and inventory transactions, and can optionally be associated with a distribution account for cost accounting. Because freight code names and descriptions must be presented in the session language, EBS follows its standard multi-language "TL" pattern: the base definition lives in ORG_FREIGHT, while translated attributes are held in ORG_FREIGHT_TL keyed by LANGUAGE.

From a heuristic Data Vault modeling perspective, this object is best classified as a link-style structure: it resolves the many-to-many relationship between a freight code and the languages in which it is described, joined to the underlying organization and language context. It carries descriptive text (DESCRIPTION) rather than being a pure transactional fact, so it can also be viewed as a satellite attached to the freight code business key.

Key Information Stored

The table is documented with 51 physical columns, of which the primary key is ORG_FREIGHT_TL_PK, composed of FREIGHT_CODE, ORGANIZATION_ID, and LANGUAGE. This composite key, not a surrogate sequence column, is the operational identity of each row. The unique index ORG_FREIGHT_TL_U1 covers the same three columns (FREIGHT_CODE, ORGANIZATION_ID, LANGUAGE), so it is the primary business-key candidate.

  • FREIGHT_CODE – the freight code identifier; the business key shared with the base freight definition.
  • ORGANIZATION_ID – the inventory organization that owns the freight code; foreign key to MTL_PARAMETERS.
  • LANGUAGE – the language of the translated description, typically a value such as US or ZHS from FND_LANGUAGES.
  • SOURCE_LANG – the source language from which the translation originated.
  • FREIGHT_CODE_TL – the translated freight code text used for display.
  • DESCRIPTION – the free-form, language-specific description of the freight code.
  • DISTRIBUTION_ACCOUNT – the GL account used to charge freight; foreign key to GL_CODE_COMBINATIONS.
  • DISABLE_DATE – the date from which the freight code is no longer usable for the given language row.
  • PARTY_ID – the trading partner or carrier associated with the freight code.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 – the standard EBS descriptive flexfield (DFF) columns for extensible, client-specific freight code attributes.
  • GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–20 – reserved global flexfield columns.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – the standard EBS audit ("WHO") columns maintained by concurrent programs and forms.

Common Use Cases and Queries

The most frequent requirement is to present freight codes in the user's language. A typical query joins the base definition to the translated row on the freight code, organization, and language, filtering to the active session language:

SELECT oft.freight_code, oft.freight_code_tl, oft.description, oft.distribution_account, oft.party_id, oft.disable_date FROM org_freight_tl oft WHERE oft.organization_id = :org_id AND oft.language = USERENV('LANG') AND (oft.disable_date IS NULL OR oft.disable_date > SYSDATE);

Warehouse and order management reporting frequently lists all enabled freight codes per organization for use in shipping and receiving forms. A second common pattern retrieves the GL distribution account assigned to a freight code, joining to GL_CODE_COMBINATIONS to resolve the account concatenation for cost analysis or freight expense reporting. Because ORGANIZATION_ID constrains the data, multi-org queries must use the organization context (or MO_GLOBAL / ORG_ID) to filter the correct inventory organization. Data-extraction and localization audits also use this table to verify that every base freight code has a translation row in each installed language, which is important when EBS is running in a multi-language environment.

Related Objects

The FK metadata documents two direct relationships, and the TL pattern implies a link to the base table:

  • ORG_FREIGHT – the base, non-translated freight code definition joined on FREIGHT_CODE and ORGANIZATION_ID.
  • MTL_PARAMETERS – the inventory organization master; joined on ORG_FREIGHT_TL.ORGANIZATION_ID = MTL_PARAMETERS.ORGANIZATION_ID.
  • GL_CODE_COMBINATIONS – the general ledger account for freight charging; joined on ORG_FREIGHT_TL.DISTRIBUTION_ACCOUNT = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
  • FND_LANGUAGES – the language list resolving the LANGUAGE and SOURCE_LANG codes to display names.
  • FND_FLEX_VALUES / FND_FLEX_VALUES_TL and the DFF setup tables – used to interpret the ATTRIBUTE and GLOBAL_ATTRIBUTE descriptive flexfield segments.

The ORG_FREIGHT (base) and ORG_FREIGHT_TL (translation) pair is typically accessed together through the Inventory setup forms and the standard Inventory open interfaces rather than a dedicated public API.