Results for “jtf_fm_group”

24 results




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

Overview

JTF_FM_GROUP is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the JTF (CRM Foundation) product family and stores information about fulfillment groups. The view exposes a denormalized, query-friendly projection of the fulfillment group data maintained by the underlying base object JTF_FM_GROUPS_ALL. Because it is a view rather than a table, it carries no independent storage; all reads are resolved at runtime against the base synonym.

The view is typically consumed by CRM fulfillment and order management components, by concurrent programs that report on group configuration, and by integration interfaces that need a stable, read-only window onto fulfillment group definitions without touching the multi-org base table directly. Its columns include the audit and multi-org attributes required for standard EBS reporting, making it suitable for both ad hoc queries and embedded LOV or report definitions.

Underlying Base Objects

Per the documented metadata, JTF_FM_GROUP is defined over a single referenced base object: JTF_FM_GROUPS_ALL (SYNONYM). The view text is a straightforward SELECT of that base:

No joins, filters, or computed expressions are present in the documented text. The view therefore mirrors the base table row for row, including soft-deleted rows where F_DELETEDFLAG is set. The _ALL suffix on the base table indicates it is a multi-organization object keyed in part by ORG_ID, so any query against the view must respect the operating unit or organization context of the calling session.

Key Columns

  • GROUP_ID — Primary identifier for the fulfillment group.
  • GROUP_NAME — User-facing name of the group, used in lists and LOVs.
  • GROUP_DESC — Descriptive text for the fulfillment group. This is the column most commonly targeted by searches such as "group_desc", since it holds the human-readable description associated with each group.
  • F_DELETEDFLAG — Soft-delete indicator; rows flagged as deleted remain physically present and should generally be excluded from active reporting.
  • ORG_ID — Organization identifier enforcing multi-org partitioning of the _ALL base table.
  • SERVER_ID — Reference to the associated server or processing resource for the group.
  • OBJECT_VERSION_NUMBER — Optimistic locking token used by the underlying entity objects.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture standard EBS who/when metadata for audit and incremental extraction.

Common Use Cases and Queries

Typical scenarios include listing active fulfillment groups for an operating unit, searching group descriptions by keyword, and feeding group metadata into CRM integration or reconciliation reports.

List active groups for the current organization:

  • SELECT group_id, group_name, group_desc FROM jtf_fm_group WHERE f_deletedflag = 'N' ORDER BY group_name;

Keyword search against the description, matching the "group_desc" intent:

  • SELECT group_id, group_name, group_desc FROM jtf_fm_group WHERE UPPER(group_desc) LIKE UPPER('%&keyword%') AND f_deletedflag = 'N';

Incremental extraction using audit columns:

  • SELECT group_id, group_name, group_desc, last_update_date, last_updated_by FROM jtf_fm_group WHERE last_update_date >= :p_since AND f_deletedflag = 'N';

Because the view performs no filtering, always add the F_DELETEDFLAG predicate and, in multi-org deployments, restrict by ORG_ID or rely on the session's org context via MO: Operating Unit or MO: Security Profile.