Search Results fnd_printer_tl




Overview
Explore in AI Chat

Overview

The FND_PRINTER_TL table is a core translation table within the Oracle E-Business Suite (EBS) Application Object Library (FND). It stores translated descriptions for printer definitions managed in the base table, FND_PRINTER. This object is essential for supporting the multilingual capabilities of the EBS system, allowing printer names and descriptions to be displayed in a user's preferred language (NLS). Its role is to decouple language-specific text from the core printer configuration data, enabling a single installation to serve users across multiple geographic regions seamlessly. The table is owned by the APPLSYS schema and is valid for both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to hold the language-specific translations for printer records. Its structure is defined by a composite primary key consisting of the PRINTER_NAME and LANGUAGE columns. The PRINTER_NAME column links the translation back to the specific printer defined in FND_PRINTER. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'D' for German) for which the translation is applicable. The most critical data column is the DESCRIPTION, which contains the translated text for the printer. Other standard translation table columns, such as SOURCE_LANG, CREATED_BY, and LAST_UPDATE_DATE, are also present to track the origin and maintenance of each translated row.

Common Use Cases and Queries

The primary use case is the dynamic display of printer information in forms and reports based on the user's session language. When a user views a list of available printers, the EBS application joins FND_PRINTER with FND_PRINTER_TL to retrieve the appropriate description. A common diagnostic or reporting query involves checking for missing translations or verifying existing ones for a given printer. For example:

  • To list all translations for a specific printer: SELECT language, description FROM apps.fnd_printer_tl WHERE printer_name = '<PRINTER_NAME>';
  • To find printers missing a translation in a specific language: SELECT p.printer_name FROM apps.fnd_printer p WHERE NOT EXISTS (SELECT 1 FROM apps.fnd_printer_tl tl WHERE tl.printer_name = p.printer_name AND tl.language = '<LANG_CODE>');

Direct data manipulation in this table is typically performed via the standard EBS translation interfaces or underlying APIs, not via manual DML.

Related Objects

FND_PRINTER_TL has a direct and singular foreign key relationship with the base table FND_PRINTER. This is documented by the foreign key from FND_PRINTER_TL.PRINTER_NAME to FND_PRINTER. The base table, FND_PRINTER, stores the technical and configuration details for each printer (e.g., driver, style, number of copies). Any process or interface that queries printer descriptions for a multilingual user interface will perform a join between these two tables using the PRINTER_NAME column. The primary key constraint FND_PRINTER_TL_PK enforces uniqueness on the combination of PRINTER_NAME and LANGUAGE, ensuring only one translation per language per printer.