Search Results tracking_group_id




Overview
Explore in AI Chat

Overview

The IGS_TR_GROUP_MEMBER table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (Integrated Global Services) schema. It functions as a junction or association table that defines the membership of individual tracking items within a tracking group. Its primary role is to manage the many-to-many relationship between tracking groups and the business documents or processes they monitor, enabling the logical grouping of related items for collective tracking, reporting, and management purposes within the application's tracking functionality.

Key Information Stored

The table stores a minimal set of columns focused on the association and audit trail. The two mandatory key columns are TRACKING_GROUP_ID and TRACKING_ID, which together form the table's primary key. TRACKING_GROUP_ID identifies the specific group, while TRACKING_ID is the system-generated identifier for a business document or process assigned to that group. This structure allows a single tracking group to contain multiple items and a single item to potentially belong to multiple groups. The remaining columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are standard EBS "Who" columns that provide a complete audit history of each record's creation and modifications.

Common Use Cases and Queries

This table is central to operations involving tracking group administration and reporting. Common use cases include listing all members of a specific tracking group for review, adding or removing items from a group via data manipulation, and generating reports that aggregate the status or attributes of all items within a group. A fundamental query to retrieve all memberships is:

SELECT TRACKING_GROUP_ID, TRACKING_ID, CREATION_DATE
FROM IGS.IGS_TR_GROUP_MEMBER
WHERE TRACKING_GROUP_ID = :GROUP_ID
ORDER BY TRACKING_ID;

For reporting, it is typically joined to the master tracking group and tracking item tables to pull descriptive information. Analysts may also query it to find all groups a specific tracking item belongs to by filtering on the TRACKING_ID column.

Related Objects

The IGS_TR_GROUP_MEMBER table maintains defined foreign key relationships with master tables, ensuring referential integrity. As per the provided relationship data:

  • Primary Key: IGS_TR_GROUP_MEMBER_PK on columns (TRACKING_GROUP_ID, TRACKING_ID).
  • Foreign Key Reference (Parent): The TRACKING_GROUP_ID column references the IGS_TR_GROUP_ALL table, which holds the definition and header information for tracking groups.
  • Foreign Key Reference (Parent): The TRACKING_ID column references the IGS_TR_ITEM_ALL table, which is the master repository for all tracking items (business documents or processes) in the system.

These relationships are critical for any join operation when building comprehensive queries that require descriptive data from the parent tables alongside the membership link stored in IGS_TR_GROUP_MEMBER.