Search Results ece_tp_group_pk

Overview

The ECE_TP_GROUP table is a core data object within the e-Commerce Gateway (EC) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for trading partner groups, which are logical collections of individual trading partner definitions. In the context of B2B and EDI integrations, trading partner groups provide a critical mechanism for managing and applying common processing rules, communication protocols, and data mappings to multiple trading partners simultaneously. This table enables administrators to efficiently organize partners—such as suppliers or customers—into functional or operational cohorts, streamlining the configuration and maintenance of complex electronic data interchange (EDI) environments.

Key Information Stored

The table's primary purpose is to define and store the unique identity and descriptive attributes of a trading partner group. While the full column list is not detailed in the provided metadata, the documented primary key structure is paramount. The column TP_GROUP_ID is the unique identifier (primary key) for each group record, enforced by the ECE_TP_GROUP_PK constraint. This ID is the critical reference point used throughout the e-Commerce Gateway to associate specific trading partners and their transaction definitions with a particular group. Other typical columns in such a table, though not explicitly listed here, would likely include a group name, description, creation date, and status field to control active usage.

Common Use Cases and Queries

A primary use case involves querying all configured groups for administrative setup or audit reporting. The TP_GROUP_ID is frequently used in WHERE clauses to retrieve specific group details or to find all trading partners belonging to a particular group via a join to the ECE_TP_HEADERS table. For instance, to identify all trading partner headers associated with a specific group ID, a common query pattern would be:

• SELECT h.tp_header_id, h.tp_site_code FROM ece_tp_headers h WHERE h.tp_group_id = <specific_id>;

Another standard operational query is to list all active trading partner groups along with a count of their member partners, which assists in managing the EDI landscape.

Related Objects

The ECE_TP_GROUP table has a direct parent-child relationship with the ECE_TP_HEADERS table, which stores the detailed definitions of individual trading partners. As documented in the foreign key metadata:

• The ECE_TP_HEADERS table references ECE_TP_GROUP via the foreign key column ECE_TP_HEADERS.TP_GROUP_ID. This column joins to the primary key (TP_GROUP_ID) of ECE_TP_GROUP, establishing that a trading partner header must belong to a single, pre-defined trading partner group.

This relationship is fundamental, ensuring data integrity and enabling the cascading of group-level configurations to the individual partner records contained within ECE_TP_HEADERS.