Results for “jtf_fm_fax_jtf_fm_groups”

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

Overview

The JTF_FM_FAX_JTF_FM_GROUPS table is a CRM Foundation (JTF) object in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores cross-reference information linking fax servers to fax groups. It serves as the intersection point between the fax server configuration defined in JTF_FM_FAX and the group definitions held in JTF_FM_GROUPS_ALL. In practical terms, the table answers the question of which fax dispatch groups are served by which fax server and dispatcher combination, enabling the CRM Foundation fax infrastructure to route outbound fax output to the appropriate group membership.

The object is classified as VALID and is owned by the JTF schema. Because the ETRM metadata is limited to structural and referential detail, no column-level comments or lookup meanings are documented; the semantics described here are inferred from the column names, the primary key composition, and the foreign key graph.

Under a heuristic Data Vault classification mined from the foreign key structure, this table is best modeled as a link table. Its primary key is composed entirely of foreign key references rather than a single generated surrogate identifier, which is the classic signature of a relationship or associative entity. Treating it as a link in a Data Vault model is a modeling suggestion and not a documented EBS designation.

Key Information Stored

The table is physically documented with 13 columns in the 12.2.2 schema, and the primary key JTF_FM_FAX_FG_PK is defined across five business columns: OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, SERVER_ID, and GROUP_ID. A second documented primary key, JTF_FM_FAX_JTF_FM_GROUPS_PK, repeats the same five columns. The most significant columns are:

• OUTPUT_ID — Foreign key referencing JTF_FM_FAX; identifies the fax output definition associated with the cross-reference.
• OUTPUT_TYPE — Together with OUTPUT_ID, forms part of the composite reference to JTF_FM_FAX, qualifying the output record type.
• DISPATCHER_ID — Identifies the dispatcher component that routes fax output; part of the JTF_FM_FAX reference and the primary key.
• SERVER_ID — Identifies the fax server; completes the composite JTF_FM_FAX reference and participates in the primary key.
• GROUP_ID — Foreign key referencing JTF_FM_GROUPS_ALL; identifies the fax group being cross-referenced to the server and dispatcher.
• SECURITY_GROUP_ID — Foreign key referencing FND_SECURITY_GROUPS, enforcing multi-org or data-security partitioning of the row.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the framework to detect concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns providing who/when lineage for the row.
• F_DELETEDFLAG — Deletion or soft-delete indicator used by the fax management framework.

There is no single surrogate primary key in the documented metadata; the business key is the five-column composite that is itself entirely foreign-key derived. This reinforces the link interpretation. No unique indexes beyond the documented primary keys are referenced in the metadata.

Common Use Cases and Queries

The primary operational use case is resolving which groups are reachable through a given fax server. A typical join retrieves group names by joining to the group registration table:

• Server-to-group mapping: join JTF_FM_FAX_JTF_FM_GROUPS to JTF_FM_GROUPS_ALL on GROUP_ID to list all groups served by a specific SERVER_ID.
• Fax output configuration reporting: join to JTF_FM_FAX on OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, and SERVER_ID to report the full dispatch configuration for each output.
• Orphan and integrity analysis: identify rows whose GROUP_ID no longer resolves in JTF_FM_GROUPS_ALL, indicating stale cross-references.
• Security-scoped reporting: filter by SECURITY_GROUP_ID to restrict results to a specific security group.
• Lifecycle auditing: use CREATION_DATE, LAST_UPDATE_DATE, and F_DELETEDFLAG to track when mappings were created, modified, or soft-deleted.

A representative query pattern joins the three tables on their documented foreign key columns, then filters on F_DELETEDFLAG = 'N' before aggregating group counts per server.

Related Objects

The following tables are the most significant objects related to this cross-reference, based on the documented foreign key graph:

• JTF_FM_FAX — Parent table for fax output definitions; joined via OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, and SERVER_ID.
• JTF_FM_GROUPS_ALL — Registration of all fax groups; joined via GROUP_ID.
• FND_SECURITY_GROUPS — Security group definitions; joined via SECURITY_GROUP_ID.

Because the table is a link entity, no child tables reference it in the documented relationship data, and it exposes no independent business identity outside the concatenated foreign keys it holds.