Search Results ece_tp_headers

Overview

The ECE_TP_HEADERS table is a core data object within the Oracle E-Business Suite e-Commerce Gateway (EC) module. It functions as the master repository for trading partner address information, a critical entity in electronic data interchange (EDI) and business-to-business (B2B) communication setups. In the context of Oracle EBS 12.1.1 and 12.2.2, this table stores the foundational header-level details that define a trading partner's location or address entity, which is then referenced by various transactional and financial components to facilitate automated, standardized data exchange with external entities such as suppliers and customers.

Key Information Stored

The table's primary identifier is the TP_HEADER_ID column, which is enforced by the primary key constraint ECE_TP_HEADERS_PK. A unique key constraint, ETH1_UK, also exists on this column, ensuring its uniqueness for data integrity. A critical foreign key column is TP_GROUP_ID, which links the trading partner address to a defined group in the ECE_TP_GROUP table. While the full column list is not detailed in the provided metadata, typical columns in such a structure would include data points for the trading partner's name, address lines, city, state, postal code, country, and contact information, alongside control attributes like status and creation details.

Common Use Cases and Queries

This table is central to configuring and managing EDI partners. Common operational scenarios include setting up new supplier or customer sites for EDI transactions, validating address data for outbound documents, and troubleshooting communication errors by verifying partner details. For reporting and support, frequent SQL queries involve joining this table with its related details and group tables. A fundamental pattern is retrieving all addresses for a specific trading partner group:

• SELECT eth.* FROM ec.ece_tp_headers eth, ec.ece_tp_group etg WHERE eth.tp_group_id = etg.tp_group_id AND etg.group_name = '&GROUP_NAME';

Another critical query validates the existence of a trading partner address before processing an outbound EDI transaction, often by joining with the ECE_TP_DETAILS table on TP_HEADER_ID.

Related Objects

The ECE_TP_HEADERS table has defined relationships with several other key EBS objects, as indicated by its foreign key constraints. It is a child table to ECE_TP_GROUP via the TP_GROUP_ID foreign key. Conversely, it acts as a parent table to two important entities: ECE_TP_DETAILS, which holds more granular information for the trading partner address, and AP_BANK_BRANCHES, linking banking information to a specific trading partner address. This relationship with the Payables bank branches table underscores the table's role in financial EDI setups, ensuring remittance advice and payment information are correctly routed to the partner's designated bank location.