Search Results fnd_printer




Overview
Explore in AI Chat

Overview

The FND_PRINTER table is a core repository within the Oracle E-Business Suite (EBS) Application Object Library (FND). It serves as the central registry for all printer definitions configured within the application. This table is fundamental to the EBS printing architecture, enabling the system to route concurrent program output, reports, and alerts to specific physical or logical printing devices. Its existence in both EBS 12.1.1 and 12.2.2 underscores its critical, unchanged role in managing print resources across the application's execution environment.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's structure is defined by its relationships and purpose. The primary key column, PRINTER_NAME, uniquely identifies each registered printer. Another critical column is PRINTER_TYPE, which is a foreign key to the FND_PRINTER_TYPES table, classifying the printer (e.g., specific driver types, operating system printers). The table likely contains additional columns to store configuration details such as the printer's operating system command, destination, number of copies, paper tray settings, and other driver-specific parameters necessary for the Concurrent Manager to execute print jobs.

Common Use Cases and Queries

This table is primarily referenced for printer administration and troubleshooting. Common operational scenarios include auditing printer assignments and diagnosing failed concurrent requests. Administrators often query this table to list all configured printers, identify which printers are assigned to specific concurrent programs or request sets, and verify printer definitions. A typical diagnostic query joins FND_PRINTER with FND_CONCURRENT_REQUESTS to find requests that failed due to printer issues.

  • Listing all registered printers: SELECT printer_name FROM applsys.fnd_printer;
  • Finding programs set to use a specific printer: SELECT concurrent_program_name FROM applsys.fnd_concurrent_programs WHERE printer_name = '<PRINTER_NAME>';
  • Auditing printer usage in recent requests: SELECT r.request_id, r.printer, p.printer_type FROM fnd_concurrent_requests r, fnd_printer p WHERE r.printer = p.printer_name AND r.actual_completion_date > SYSDATE-1;

Related Objects

The FND_PRINTER table is a central hub with numerous foreign key relationships, as documented in the metadata. These relationships demonstrate its integration across key EBS modules.

  • FND_PRINTER_TYPES: Joined via FND_PRINTER.PRINTER_TYPE. Defines the category of the printer.
  • FND_CONCURRENT_PROGRAMS: Joined via FND_CONCURRENT_PROGRAMS.PRINTER_NAME. Associates a default printer with a concurrent program.
  • FND_CONCURRENT_REQUESTS: Joined via FND_CONCURRENT_REQUESTS.PRINTER. Stores the printer assigned for a specific request instance.
  • FND_REQUEST_SETS / FND_REQUEST_SET_PROGRAMS / FND_RUN_REQUESTS: Joined via their respective PRINTER columns. Manages printer assignments for request sets and their stages.
  • ALR_DISTRIBUTION_LISTS: Joined via ALR_DISTRIBUTION_LISTS.PRINTER. Used for routing Alert Manager notifications.
  • FND_PRINTER_TL: Joined via FND_PRINTER_TL.PRINTER_NAME. Provides translated names for the printer.
  • SO_REPORT_PRINTERS: Joined via SO_REPORT_PRINTERS.PRINTER_NAME. Links printers to specific reports in the Order Management suite.