Search Results fnd_printer_styles




Overview
Explore in AI Chat

Overview

The FND_PRINTER_STYLES table is a core reference table within the Oracle E-Business Suite Application Object Library (FND). It serves as the master repository for defining printer styles, which are configurations that dictate the physical formatting and output characteristics for printed reports generated by concurrent programs. In the context of Oracle EBS 12.1.1 and 12.2.2, printer styles are essential for controlling aspects such as page orientation, font, margins, and paper trays, ensuring reports are correctly formatted for specific printers or output destinations. This table provides the foundational data that links report definitions and execution requests to their required print formatting instructions.

Key Information Stored

The table's primary data is the unique identifier for each printer style configuration. Its structure is defined by two primary keys, indicating the critical columns for data integrity and access. The PRINTER_STYLE_NAME column is the principal unique identifier and descriptive code for the style (e.g., 'LANDSCAPE', 'ENVELOPE', 'A4'). The SEQUENCE column provides a secondary unique constraint, likely used for ordering or internal processing. While the provided metadata does not list all columns, typical related tables suggest this table stores the technical name and key attributes of a style, with translatable descriptions held in the related FND_PRINTER_STYLES_TL table.

Common Use Cases and Queries

The primary use case is to query and assign print formatting rules to concurrent programs and requests. System administrators may query this table to audit or manage available styles. A common reporting need is to list all concurrent programs and their assigned output print styles. A sample query for this would join FND_CONCURRENT_PROGRAMS to FND_PRINTER_STYLES:

  • SELECT cp.user_concurrent_program_name, ps.printer_style_name FROM fnd_concurrent_programs cp, fnd_printer_styles ps WHERE cp.output_print_style = ps.printer_style_name;

Another frequent operational query is to identify all concurrent requests submitted with a specific print style, which involves joining FND_CONCURRENT_REQUESTS to this table on the PRINT_STYLE column.

Related Objects

FND_PRINTER_STYLES is a central reference point for several key EBS objects, primarily governing report output. The documented foreign key relationships are:

  • FND_CONCURRENT_PROGRAMS: Links via OUTPUT_PRINT_STYLE to define the default print style for a program.
  • FND_CONCURRENT_REQUESTS: Links via PRINT_STYLE to record the style used for a specific request instance.
  • FND_PRINTER_INFORMATION: Links via PRINTER_STYLE to associate styles with specific printer definitions.
  • FND_PRINTER_STYLES_TL: Links via PRINTER_STYLE_NAME to store translated descriptions of the style.
  • FND_REQUEST_SETS: Links via PRINT_STYLE for the set's output.
  • FND_REQUEST_SET_PROGRAMS: Links via PRINT_STYLE for individual programs within a set.
  • FND_RUN_REQUESTS: Links via PRINT_STYLE for scheduled request submissions.

These relationships underscore the table's role in propagating print formatting rules throughout the concurrent processing subsystem.