Results for “pon_negotiation_styles_tl”

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

Overview

PON_NEGOTIATION_STYLES_TL is a translation (TL) table within the PON (Sourcing) schema of Oracle E-Business Suite, holding language-specific descriptive text for negotiation styles. A "negotiation style" in Oracle Sourcing defines the configurable behavioral template applied to a negotiation document — controlling defaults such as pricing, visibility, and scoring behavior. The base, language-independent attributes live in the corresponding base table (PON_NEGOTIATION_STYLES_B), while PON_NEGOTIATION_STYLES_TL stores the human-readable, translatable strings — the style name and description — for each installed language.

The table is owned by the PON schema and is documented as VALID across EBS 12.1.1 and 12.2.2. It exists to support Oracle's Multi-Language Support (MLS/Translation) framework, in which each translatable row is keyed by the combination of the entity identifier (STYLE_ID) and the LANGUAGE code. This separation allows a single negotiation style to present locale-appropriate names and descriptions without duplicating the functional configuration across languages.

The heuristic Data Vault classification mined from the foreign-key structure is standalone. From a modeling perspective this suggests the table is best treated as a self-contained satellite-like construct — a descriptive/attribute store keyed by a business entity — rather than a true hub or link. This classification reflects the absence of a dense network of foreign keys typically associated with fact or link tables.

Key Information Stored

The table is documented with 11 columns. The most significant for functional and reporting purposes are:

• STYLE_ID — The surrogate/business identifier of the negotiation style. This column links the translation row back to its base style definition and is the primary join key. It is documented as a foreign key referencing HR_ADE_STYLES.
• STYLE_NAME — The translated display name of the negotiation style, presented to users in the selected language.
• DESCRIPTION — The translated longer text explaining the purpose or behavior of the style.
• LANGUAGE — The language code for which the STYLE_NAME and DESCRIPTION values are supplied. Together with STYLE_ID it identifies a unique translatable row.
• SOURCE_LANG — The language code of the source (originally authored) text, used by the MLS framework to track translation provenance.
• ZD_EDITION_NAME — The editioning column introduced by the AD Online Patching / Edition-Based Redefinition (EBR) architecture. It supports multiple editioned versions of the same logical row in 12.2.x environments.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard Oracle WHO columns recording audit lineage for each translatable row.

The unique index PON_NEGOTIATION_STYLES_TL_U1 on (STYLE_ID, LANGUAGE, ZD_EDITION_NAME) is the business-key candidate, enforcing one translation per language per edition per style.

Common Use Cases and Queries

Typical uses include Sourcing setup screens that display style names in the user's active language, and reports comparing style availability across deployed languages. A common query shows translated names filtered by language:

SELECT style_id, style_name, description FROM pon_negotiation_styles_tl WHERE language = USERENV('LANG') AND zd_edition_name = 'ORA$BASE';

To identify styles lacking a translation for a given language, a left-join pattern is used:

SELECT b.style_id FROM pon_negotiation_styles_b b LEFT JOIN pon_negotiation_styles_tl tl ON b.style_id = tl.style_id AND tl.language = 'US' WHERE tl.style_id IS NULL;

Related Objects

• PON_NEGOTIATION_STYLES_B — The base table holding language-independent style configuration; joined on STYLE_ID. The TL row extends the B row for display purposes.
• HR_ADE_STYLES — Referenced by the documented foreign key STYLE_ID, indicating the underlying style/definition entity used by the sourcing engine.
• PON_NEGOTIATIONS_ALL — Negotiation documents that reference an associated style; useful for reporting style usage.
• PON_AUC_HEADERS / negotiation header tables — Header-level records that carry the chosen negotiation style for a specific event.
• FND_LANGUAGES — Reference table supplying the set of installed languages that populate the LANGUAGE and SOURCE_LANG columns.
• PON_NEGOTIATION_STYLES_TL (self via MLS views) — Oracle commonly exposes this through MLS-aware views that join the _B and _TL tables, so application code rarely queries the TL table directly.