Search Results qp_segments_tl




Overview
Explore in AI Chat

Overview

QP_SEGMENTS_TL is a translation (TL) table within the QP — Advanced Pricing module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. As indicated by its documented description, it stores the language-dependent attribute names used by the Advanced Pricing segmentation model. Segmented attributes in QP allow pricing administrators to define custom qualifier and pricing attribute contexts, and QP_SEGMENTS_TL provides the multilingual display names and descriptions associated with each segment defined in the base table.

In Oracle EBS, "_TL" tables pair with a base entity and hold translated columns keyed by a LANGUAGE code, with SOURCE_LANG tracking the language from which the translation originated. QP_SEGMENTS_TL follows this convention, carrying seeded (Oracle-provided) and user-defined name/description columns side by side so that Oracle-supplied terminology and customer-authored overrides remain distinguishable.

The provided metadata assigns this table a heuristic Data Vault classification of standalone. From a modeling perspective, this suggests the table is not embedded as a satellite within a conventional hub-and-link structure; it may most naturally be treated as a descriptor or reference table subordinate to its parent segment entity, carrying language-qualified descriptive attributes rather than transactional relationships.

Key Information Stored

The table contains 13 documented columns in the 12.2.2 physical schema. The most significant are:

The unique index QP_SEGMENTS_TL_U1 on (SEGMENT_ID, LANGUAGE, ZD_EDITION_NAME) identifies the business-key candidate: the combination of the segment identifier, language, and edition uniquely resolves each row. SEGMENT_ID alone is not unique, since multiple language rows exist per segment.

Common Use Cases and Queries

Reporting and integration scenarios typically require joining the translation to the base segment definition while filtering on language. A representative query retrieves the display name for a given language:

  • Retrieve user-preferred names with fallback: SELECT segment_id, NVL(user_segment_name, seeded_segment_name) name FROM qp_segments_tl WHERE language = USERENV('LANG').
  • Audit translations completeness: GROUP BY segment_id to detect segments lacking a row for a required language.
  • Identify customer customizations: compare USER_SEGMENT_NAME against SEEDED_SEGMENT_NAME to find overridden terminology.
  • Join to the parent segment table on SEGMENT_ID to build multilingual lookup views for pricing setup screens.
  • Filter by ZD_EDITION_NAME when querying across the 12.2 editioning boundary to isolate the active edition.

Because the table is small and descriptive in nature, it is frequently used as a lookup source in BI Publisher reports and personalized OAF/Forms LOVs that present segment names to end users.

Related Objects

  • CSF_TDS_SEGMENTS — Referenced by the foreign key QP_SEGMENTS_TL.SEGMENT_ID; the parent definition of the segment.
  • QP_SEGMENTS — The base (non-translated) segment table supplying attributes common to all languages.
  • QP_SEGMENTS_TL_U1 — Unique index enforcing the (SEGMENT_ID, LANGUAGE, ZD_EDITION_NAME) key.
  • QP_PRICING_ATTRIBUTES / QP_QUALIFIERS — Consume segment identifiers when building pricing and qualifier contexts in Advanced Pricing.
  • FND_LANGUAGES — Provides the valid LANGUAGE and SOURCE_LANG codes referenced by translated rows.
  • EBS Online Patching editioning views — Applications access the table through editioning views that expose ZD_EDITION_NAME, relevant chiefly in 12.2.2.