Search Results printer_style

Overview

The FND_PRINTER_INFORMATION table is a core data object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a critical junction table in the application's printing architecture, defining the relationships between printer types and the specific printer styles and drivers they support. Its primary role is to store configuration data that enables the EBS system to correctly format and route print jobs to various physical and logical printers based on their defined capabilities and the document's formatting requirements. This table is essential for the proper functioning of concurrent manager output and other reporting processes.

Key Information Stored

The table's structure is defined by its primary key, which is a composite of two columns that establish the core relationship. The PRINTER_TYPE column identifies a category or model of printer, as defined in the FND_PRINTER_TYPES table. The PRINTER_STYLE column specifies a particular print format or driver, as defined in the FND_PRINTER_STYLES table. While the provided ETRM metadata does not list additional columns, this table typically contains other attributes that further refine the printer-driver association, such as driver-specific parameters or sequence numbers. The combination stored in this table dictates which formatting logic (style/driver) is applicable for a given printer type.

Common Use Cases and Queries

The primary use case for this table is the configuration and troubleshooting of the EBS printing subsystem. System administrators query this table to verify that a newly added printer type is correctly associated with the appropriate styles, or to diagnose printing failures by ensuring the required driver mappings exist. A common reporting query involves joining to the related tables to produce a human-readable list of all configured printer types and their available styles.

• Sample Query: To list all printer information with descriptions:
  SELECT fpi.printer_type, fpt.printer_type_name, fpi.printer_style, fps.style_name
FROM apps.fnd_printer_information fpi,
     apps.fnd_printer_types fpt,
     apps.fnd_printer_styles fps
WHERE fpi.printer_type = fpt.printer_type
AND fpi.printer_style = fps.printer_style
ORDER BY 1, 3;
• This data is also referenced internally by the Concurrent Manager when processing a print request to determine the correct output formatting and destination.

Related Objects

As indicated by the foreign key constraints in the metadata, FND_PRINTER_INFORMATION is centrally linked to two key reference tables. It is a child table to both FND_PRINTER_TYPES and FND_PRINTER_STYLES, ensuring referential integrity in the printing configuration.

• FND_PRINTER_TYPES: Foreign key from FND_PRINTER_INFORMATION.PRINTER_TYPE to this table. It defines the printer types (e.g., specific printer models or logical destinations like "Text," "PDF," "HP LaserJet") available in the system.
• FND_PRINTER_STYLES: Foreign key from FND_PRINTER_INFORMATION.PRINTER_STYLE to this table. It defines the available printing styles and drivers, which control the formatting and technical output of the print job.

Together, these three tables form the foundational data model for printer management within Oracle EBS, with FND_PRINTER_INFORMATION acting as the associative entity that links types to their permissible styles.