Results for “fnd_printer_information”

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

Overview

FND_PRINTER_INFORMATION is an Oracle E-Business Suite Application Object Library (FND) configuration table that defines the valid combinations of printer types and printer styles, together with the printer driver associated with each pairing. In EBS 12.1.1 and 12.2.2 it is owned by the APPLSYS schema and resides in the FND product family. Its functional purpose is to control how a concurrent program's print output is rendered: the printer type establishes the physical or logical class of device, the printer style establishes the formatting convention, and the driver column supplies the executable driver used when the output is sent to that printer.

The table functions as an intersection or cross-reference between two parent entities — FND_PRINTER_TYPES and FND_PRINTER_STYLES — and therefore behaves as an association rather than a master entity. The Data Vault classification supplied in the metadata is link; modelled in that style, FND_PRINTER_INFORMATION would represent the relationship between a printer-type hub and a printer-style hub, with the association itself (the driver assignment) carried as its descriptive payload.

Key Information Stored

The composite primary key, enforced through FND_PRINTER_INFORMATION_PK, is (PRINTER_TYPE, PRINTER_STYLE). Both components are foreign keys, so the primary key is entirely composed of references to the two parent tables. Because the primary key is already the full business key, no separate surrogate identifier exists in the documented metadata; the unique index FND_PRINTER_INFORMATION_U1 (PRINTER_TYPE, PRINTER_STYLE, ZD_EDITION_NAME) extends the key with the edition discriminator used by the 12.2 online patching architecture.

• PRINTER_TYPE — foreign key to FND_PRINTER_TYPES; identifies the device or device class.
• PRINTER_STYLE — foreign key to FND_PRINTER_STYLES; identifies the output formatting style.
• PRINTER_DRIVER — the driver associated with the type/style combination; the principal non-key attribute of the row.
• ZD_EDITION_NAME — edition identifier supporting the 12.2.2 editioning model; part of the unique index U1.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording when and by whom the row was last changed and the login context.
• CREATION_DATE, CREATED_BY — standard WHO audit columns recording row creation.

Nine columns are documented in total; the two key columns, the driver, the edition column, and the five audit columns constitute the complete documented structure.

Common Use Cases and Queries

The table is consulted whenever a concurrent request specifies a printer type and style at submission time; the application resolves the driver to be used from this table. Administrators query it when diagnosing print-formatting behaviour, verifying that a requested type/style pairing is actually defined, or auditing which driver is attached to a given combination.

• Listing all styles available for a given printer type:
  SELECT printer_style, printer_driver FROM fnd_printer_information WHERE printer_type = :type;
• Resolving the driver for a submitted request:
  SELECT printer_driver FROM fnd_printer_information WHERE printer_type = :type AND printer_style = :style;
• Detecting orphaned or misconfigured rows by outer-joining both parents and filtering for NULLs.
• Reporting on edit history using LAST_UPDATED_BY and LAST_UPDATE_DATE.
• In 12.2.2, filtering by ZD_EDITION_NAME where edition-aware queries are required.

Related Objects

• FND_PRINTER_TYPES — parent table; join on PRINTER_TYPE.
• FND_PRINTER_STYLES — parent table; join on PRINTER_STYLE.
• FND_PRINTER_INFORMATION_PK — composite primary key constraint on (PRINTER_TYPE, PRINTER_STYLE).
• FND_PRINTER_INFORMATION_U1 — unique index on (PRINTER_TYPE, PRINTER_STYLE, ZD_EDITION_NAME).
• FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS — concurrent manager objects whose print settings are validated against printer type and style definitions.
• FND_PRINTER_DRIVERS — the driver registry against which PRINTER_DRIVER values are resolved.
• FND_CONCURRENT_PROGRAM_SERIAL — related concurrent processing metadata frequently examined alongside printer configuration.