Results for “reset_string”

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

Overview

FND_PRINTER_TYPES is a reference (lookup) table owned by the APPLSYS schema within the FND – Application Object Library product of Oracle E-Business Suite. Its documented description is simply "Printer Types." The table functions as the master definition list for printer type codes that the EBS printing infrastructure uses to classify and drive print behavior for registered printers. As a small, slowly changing reference table, it sits at the top of the printing configuration hierarchy: every physical or logical printer registered in the environment resolves to exactly one printer type code stored here.

From a data modeling perspective, the ETRM relationship metadata classifies FND_PRINTER_TYPES as hub-leaning. In Data Vault terms this suggests treating PRINTER_TYPE as a business key hub, with the descriptive attributes (such as DESCRIPTION and RESET_STRING) modeled as satellite attributes and the two inbound foreign keys from FND_PRINTER and FND_PRINTER_INFORMATION treated as links. This classification is a heuristic mined from the foreign-key structure and should be regarded as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The documented physical schema contains nine columns. The most significant are:

• PRINTER_TYPE — The business key and column of the primary key constraint FND_PRINTER_TYPES_PK. It is also the first column of the unique index FND_PRINTER_TYPES_U1. This is the value referenced by dependent printing tables.
• ZD_EDITION_NAME — The editioning column that participates in the unique key FND_PRINTER_TYPES_U1 (PRINTER_TYPE, ZD_EDITION_NAME), supporting Oracle EBS online patching in 12.2.x.
• DESCRIPTION — The user-facing label for the printer type code, used in lookup and list-of-values displays.
• RESET_STRING — The control string emitted to reset a printer to a known state, relevant to raw and character-mode printing.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — The standard EBS WHO (audit) columns capturing insert and update provenance.

Note that PRINTER_TYPE serves simultaneously as both surrogate primary key and business-key candidate in this table, since it appears in FND_PRINTER_TYPES_PK and in the leading position of FND_PRINTER_TYPES_U1.

Common Use Cases and Queries

Typical scenarios include validating a printer type before registering a printer, listing the descriptive labels for a configuration report, and joining printing setup data to resolve human-readable type descriptions. A simple lookup query follows:

• SELECT PRINTER_TYPE, DESCRIPTION, RESET_STRING FROM APPLSYS.FND_PRINTER_TYPES ORDER BY PRINTER_TYPE;
• SELECT p.PRINTER_NAME, p.PRINTER_TYPE, t.DESCRIPTION FROM FND_PRINTER p JOIN FND_PRINTER_TYPES t ON p.PRINTER_TYPE = t.PRINTER_TYPE;

Reporting use cases commonly include auditing which printer types are actually in use versus defined, and exporting the reference set for migration or environment comparison between 12.1.1 and 12.2.2 instances.

Related Objects

The documented foreign-key relationships establish the following dependents:

• FND_PRINTER — references FND_PRINTER_TYPES via FND_PRINTER.PRINTER_TYPE, associating each registered printer with its type.
• FND_PRINTER_INFORMATION — references FND_PRINTER_TYPES via FND_PRINTER_INFORMATION.PRINTER_TYPE, holding printer type metadata used by the printing framework.

These two tables are the principal consumers of the reference data and the primary join partners for any query that needs to resolve printer type descriptions across the EBS printing configuration model.