Results for “fnd_printer_styles_tl”

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

Overview

FND_PRINTER_STYLES_TL is the translation table for FND_PRINTER_STYLES, residing in the APPLSYS schema and belonging to the FND – Application Object Library product. In Oracle EBS 12.1.1 and 12.2.2, printer styles define the formatting directives (such as character pitch, page length, and escape sequences) applied when concurrent requests are sent to a physical or network printer. Because Oracle EBS is deployed internationally, the display names for these styles must be presented in the user's session language. FND_PRINTER_STYLES_TL stores the language-specific text for each printer style, while the parent FND_PRINTER_STYLES table stores the language-independent definition, driver information, and style logic.

The table is a translation (TL) companion, meaning it shares its primary key with the base table plus a LANGUAGE column. Under a heuristic Data Vault classification, this object is satellite-leaning: it carries descriptive, context-dependent attributes (translated names) keyed to the parent entity rather than acting as an independent hub or an associative link. Modeling guidance would treat FND_PRINTER_STYLES as the hub and this table as a satellite with LANGUAGE as part of the driving key.

Key Information Stored

The table contains 10 documented columns. The most significant are:

• PRINTER_STYLE_NAME – The internal style identifier and the join column to the parent FND_PRINTER_STYLES table. It forms the first component of the primary key FND_PRINTER_STYLES_TL_PK.
• LANGUAGE – The NLS language code for the translated row, forming the second component of the primary key.
• USER_PRINTER_STYLE_NAME – The user-facing, translated display name shown in the Printer Styles setup form and printer selection lists, presented in the session language.
• SOURCE_LANG – The base language in which the row was originally authored, used by the translation framework to determine whether a translation is current.
• ZD_EDITION_NAME – The editioning column introduced in 12.2 Online Patching, partitioning the table by AD/Z patching edition.
• Audit columns – LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN capture who created and modified each translated row and when.

The documented unique indexes identify two business-key candidates: FND_PRINTER_STYLES_TL_U1 (PRINTER_STYLE_NAME, LANGUAGE, ZD_EDITION_NAME) and FND_PRINTER_STYLES_TL_U2 (USER_PRINTER_STYLE_NAME, LANGUAGE, ZD_EDITION_NAME). The second enforces that a translated display name is unique within a language, which is essential to keep printer style selection unambiguous in the UI. In contrast to a pure surrogate key, these unique constraints carry real business meaning.

Common Use Cases and Queries

The primary use case is retrieving the translated style name for display. A typical join returns the language-specific label alongside the parent definition:

• Reporting available printer styles for a locale: SELECT tl.printer_style_name, tl.user_printer_style_name FROM fnd_printer_styles_tl tl WHERE tl.language = USERENV('LANG');
• Joining to the base table: SELECT ps.printer_style_name, tl.user_printer_style_name FROM fnd_printer_styles ps, fnd_printer_styles_tl tl WHERE ps.printer_style_name = tl.printer_style_name AND tl.language = USERENV('LANG');
• Diagnosing missing or stale translations by comparing SOURCE_LANG against rows absent for a given LANGUAGE.
• Auditing changes to display names via LAST_UPDATED_BY and LAST_UPDATE_DATE.

In 12.2 environments, queries should account for ZD_EDITION_NAME to ensure the correct patching edition is read.

Related Objects

• FND_PRINTER_STYLES – The parent table; joined on PRINTER_STYLE_NAME. It holds the driver and style logic that the TL row names.
• FND_PRINTER_STYLES_TL_PK / _U1 / _U2 – Primary and unique constraints enforcing key uniqueness.
• FND_PRINTER_DRIVERS – Related printer driver definitions referenced by the parent table.
• FND_PRINTERS – Printer definitions that reference styles during concurrent request submission.
• FND_CONCURRENT_REQUESTS – Concurrent programs whose output formatting is governed by the associated printer style.
• FND_LANGUAGES – Provides the LANGUAGE values used in translation joins.