Results for “jtf_fm_email_jtf_fm_groups”

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

Overview

The JTF.JTF_FM_EMAIL_JTF_FM_GROUPS table is a CRM Foundation (JTF) data object within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store cross-reference information that associates email servers with the groups defined in the CRM Foundation email framework. The table therefore functions as an intersection or association entity, resolving a many-to-many relationship between email server configurations and their corresponding group definitions.

Based on the foreign key structure disclosed in the ETRM metadata, this table is heuristically classified as a Data Vault link. The composite primary key JTF_FM_EMAIL_FG_PK, spanning OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, SERVER_ID, and GROUP_ID, is characteristic of a link construct that binds multiple hubs (email, server, group, dispatcher) together. This classification is a modeling suggestion rather than a physical design requirement; the actual object is a standard relational intersection table.

Key Information Stored

The table contains thirteen documented columns. The most significant are listed below.

• OUTPUT_ID — Participates in the primary key and in the foreign key to JTF_FM_EMAIL. Identifies the email output record associated with the cross-reference.
• OUTPUT_TYPE — Participates in the primary key and the JTF_FM_EMAIL foreign key, qualifying the output record type.
• DISPATCHER_ID — Part of the primary key; identifies the dispatcher component used by the email infrastructure.
• SERVER_ID — Part of the primary key; identifies the email server involved in the association.
• GROUP_ID — Part of the primary key and the foreign key to JTF_FM_GROUPS_ALL; identifies the CRM Foundation group linked to the server.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group data isolation.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the framework for concurrent update control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing change tracking.
• CREATION_DATE, CREATED_BY — Standard WHO audit columns capturing record creation details.
• F_DELETEDFLAG — Deletion indicator used by the CRM Foundation framework for logical deletes.

The surrogate primary key is documented as JTF_FM_EMAIL_FG_PK, composed of the five business-meaningful columns above. No separate single-column surrogate is defined, so the composite key itself serves as both primary key and unique identifier. The columns OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, SERVER_ID, and GROUP_ID constitute the business-key candidates reflected in the JTF_FM_EMAIL_JTF_FM_GROUPS_PK unique index.

Common Use Cases and Queries

Typical scenarios involve resolving which groups are served by a given email server, or identifying the servers and dispatchers associated with a specific group. A join query pattern follows:

• Querying servers by group: SELECT e.SERVER_ID, e.DISPATCHER_ID FROM JTF.JTF_FM_EMAIL_JTF_FM_GROUPS e WHERE e.GROUP_ID = :group_id.
• Resolving email output to group: SELECT g.GROUP_ID FROM JTF.JTF_FM_EMAIL_JTF_FM_GROUPS g WHERE g.OUTPUT_ID = :output_id AND g.OUTPUT_TYPE = :output_type.
• Reporting on active associations: filter on F_DELETEDFLAG = 'N' to exclude logically deleted rows.
• Security-group-scoped queries: constrain by SECURITY_GROUP_ID when reporting across multiple operating units.

These queries are commonly used during email framework configuration validation, migration audits, and troubleshooting of CRM Foundation email routing.

Related Objects

• JTF_FM_EMAIL — Referenced via OUTPUT_ID, OUTPUT_TYPE, DISPATCHER_ID, and SERVER_ID. Holds the email server configuration records.
• JTF_FM_GROUPS_ALL — Referenced via GROUP_ID. Holds the CRM Foundation group definitions.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID. Provides security-group isolation metadata.
• JTF_FM_EMAIL_JTF_FM_GROUPS_PK — The unique index enforcing the composite business key.
• JTF_FM_EMAIL_FG_PK — The documented primary key constraint.

Together these objects form the email-to-group association layer within the CRM Foundation module, supporting routing and dispatch configuration across Oracle EBS releases 12.1.1 and 12.2.2.