Results for “jtf_fm_printer_groups_pk”

6 results




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

Overview

The JTF.JTF_FM_PRINTER_JTF_FM_GROUPS table is a cross-reference (association) table within the CRM Foundation (JTF) product family of Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in ETRM, its purpose is to "store cross reference info about printers and groups." Functionally, it resolves a many-to-many relationship between print output devices (defined in JTF_FM_PRINTER) and logical printer groups (defined in JTF_FM_GROUPS_ALL), enabling the document delivery and print management infrastructure to associate a discrete printer with one or more routing or organizational groups.

From a heuristic Data Vault modeling perspective, the mined FK structure classifies this table as a link. This classification is a modeling suggestion: the table sits at the intersection of two business entities (printer and group) and carries no descriptive attributes about either entity itself, which is the defining characteristic of a link table in Data Vault 2.0. Its grain is the combination of the two referenced keys.

Key Information Stored

The documented physical schema contains 13 columns. The most significant are described below.

  • GROUP_ID — Foreign key to JTF_FM_GROUPS_ALL; identifies the printer group to which a device is assigned. The _ALL suffix indicates this column participates in Oracle multi-org (MOAC) security semantics.
  • OUTPUT_ID — Foreign key component referencing JTF_FM_PRINTER; identifies the printer or output device.
  • OUTPUT_TYPE — Discriminator column used in conjunction with OUTPUT_ID to qualify the printer reference.
  • DISPATCHER_ID — Identifies the dispatcher component responsible for the print job routing.
  • SERVER_ID — Identifies the server on which the dispatcher/printer registration resides. Together with OUTPUT_ID, OUTPUT_TYPE, and DISPATCHER_ID, this forms a composite reference to the printer record.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing row-level multi-org security.
  • F_DELETEDFLAG — Soft-delete indicator; active rows are typically filtered on this column.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF framework to detect concurrent updates.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO columns recording audit and change history.

The primary key is documented as JTF_FM_PRINTER_GROUPS_PK (and an alternate JTF_FM_PRINTER_JTF_FM_GROUP_PK) spanning GROUP_ID, OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, and SERVER_ID. This composite key is the surrogate identifier; GROUP_ID and OUTPUT_ID are the business-key candidates that carry semantic meaning.

Common Use Cases and Queries

Typical usage centers on print management and CRM document delivery configuration. Administrators query this table to determine which printers belong to a given group, or which groups a specific printer serves.

  • Group membership listing: joining to JTF_FM_GROUPS_ALL and JTF_FM_PRINTER to display printer-to-group assignments.
  • Security-scoped reporting: filtering by SECURITY_GROUP_ID to respect MOAC boundaries.
  • Integrity checks: identifying orphaned cross-reference rows where the printer or group no longer exists, or rows flagged with F_DELETEDFLAG.

A representative query pattern is:

  • SELECT g.group_id, p.output_id FROM jtf_fm_printer_jtf_fm_groups g, jtf_fm_groups_all grp, jtf_fm_printer p WHERE g.group_id = grp.group_id AND g.output_id = p.output_id AND g.f_deletedflag = 'N';

Related Objects

  • JTF_FM_PRINTER — referenced via OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, and SERVER_ID; holds printer/output device definitions.
  • JTF_FM_GROUPS_ALL — referenced via GROUP_ID; holds printer group definitions with multi-org support.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; controls MOAC security grouping.
  • Related JTF Foundation print infrastructure tables and the OAF-based print administration UI that read and maintain these cross-reference rows.

Because this is a pure association table, it should be treated as a link in any downstream warehouse model, resolving the printer-to-group relationship without carrying descriptive attributes of its own.