Search Results ece_tp_headers




Overview
Explore in AI Chat

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.

  • Table: ECE_TP_HEADERS 12.2.2

    owner:EC,  object_type:TABLE,  fnd_design_data:EC.ECE_TP_HEADERS,  object_name:ECE_TP_HEADERS,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the information for trading partner address entity. ,  implementation_dba_data: EC.ECE_TP_HEADERS , 

  • Table: ECE_TP_HEADERS 12.1.1

    owner:EC,  object_type:TABLE,  fnd_design_data:EC.ECE_TP_HEADERS,  object_name:ECE_TP_HEADERS,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the information for trading partner address entity. ,  implementation_dba_data: EC.ECE_TP_HEADERS , 

  • Table: ECE_TP_DETAILS 12.1.1

    owner:EC,  object_type:TABLE,  fnd_design_data:EC.ECE_TP_DETAILS,  object_name:ECE_TP_DETAILS,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the information for the trading partner processing rules. ,  implementation_dba_data: EC.ECE_TP_DETAILS , 

  • Table: ECE_TP_DETAILS 12.2.2

    owner:EC,  object_type:TABLE,  fnd_design_data:EC.ECE_TP_DETAILS,  object_name:ECE_TP_DETAILS,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the information for the trading partner processing rules. ,  implementation_dba_data: EC.ECE_TP_DETAILS , 

  • Table: ECE_TP_GROUP 12.1.1

    owner:EC,  object_type:TABLE,  fnd_design_data:EC.ECE_TP_GROUP,  object_name:ECE_TP_GROUP,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the information for a trading partner group representing a collection of trading partner definitions. ,  implementation_dba_data: EC.ECE_TP_GROUP , 

  • Table: ECE_TP_GROUP 12.2.2

    owner:EC,  object_type:TABLE,  fnd_design_data:EC.ECE_TP_GROUP,  object_name:ECE_TP_GROUP,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the information for a trading partner group representing a collection of trading partner definitions. ,  implementation_dba_data: EC.ECE_TP_GROUP , 

  • View: ECE_ADDRESS_TP 12.1.1

    product: EC - e-Commerce Gateway ,  implementation_dba_data: Not implemented in this database , 

  • View: ECE_ADDRESS_TP 12.2.2

    product: EC - e-Commerce Gateway ,  implementation_dba_data: Not implemented in this database , 

  • View: ECE_CDMO_TRX_NUMBER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_CDMO_TRX_NUMBER_V,  object_name:ECE_CDMO_TRX_NUMBER_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the credit/debit memo number for the customer for outbound Credit/Debit Memo (812 - CREADV / DEBADV) transaction. ,  implementation_dba_data: APPS.ECE_CDMO_TRX_NUMBER_V , 

  • View: ECE_CDMO_TRX_NUMBER_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_CDMO_TRX_NUMBER_V,  object_name:ECE_CDMO_TRX_NUMBER_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: Contains the credit/debit memo number for the customer for outbound Credit/Debit Memo (812 - CREADV / DEBADV) transaction. ,  implementation_dba_data: APPS.ECE_CDMO_TRX_NUMBER_V , 

  • View: ECE_ADVO_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_ADVO_HEADERS_V,  object_name:ECE_ADVO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A ,  implementation_dba_data: APPS.ECE_ADVO_HEADERS_V , 

  • View: ECE_MVSTO_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_MVSTO_HEADERS_V,  object_name:ECE_MVSTO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM ,  implementation_dba_data: APPS.ECE_MVSTO_HEADERS_V , 

  • View: ECE_MVSTO_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_MVSTO_HEADERS_V,  object_name:ECE_MVSTO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM ,  implementation_dba_data: APPS.ECE_MVSTO_HEADERS_V , 

  • View: ECE_ADVO_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_ADVO_HEADERS_V,  object_name:ECE_ADVO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A ,  implementation_dba_data: APPS.ECE_ADVO_HEADERS_V , 

  • View: ECE_DSNO_DELIVERY_ATTRIBS_V 12.1.1

    product: EC - e-Commerce Gateway ,  description: No longer used ,  implementation_dba_data: Not implemented in this database , 

  • View: ECE_DSNO_DELIVERY_ATTRIBS_V 12.2.2

    product: EC - e-Commerce Gateway ,  description: No longer used ,  implementation_dba_data: Not implemented in this database , 

  • View: ECE_SSSO_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_SSSO_HEADERS_V,  object_name:ECE_SSSO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Shipping Schedule Header View@rep:category BUSINESS_ENTITY CHV_SHIPPING ,  implementation_dba_data: APPS.ECE_SSSO_HEADERS_V , 

  • View: ECE_POO_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POO_HEADERS_V,  object_name:ECE_POO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: /*#* This view extracts header information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO * @rep:lifecycle active* @rep:displayname Purchase Order Header View* @rep:category BUSINESS_ENTI ,  implementation_dba_data: APPS.ECE_POO_HEADERS_V , 

  • View: ECE_POO_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POO_HEADERS_V,  object_name:ECE_POO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: /*#* This view extracts header information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO * @rep:lifecycle active* @rep:displayname Purchase Order Header View* @rep:category BUSINESS_ENTI ,  implementation_dba_data: APPS.ECE_POO_HEADERS_V , 

  • View: ECE_POCO_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POCO_HEADERS_V,  object_name:ECE_POCO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Header View@rep:category BUSINESS_ENTITY PO_PU ,  implementation_dba_data: APPS.ECE_POCO_HEADERS_V , 

  • View: ECE_PYO_PAYMENT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_PYO_PAYMENT_V,  object_name:ECE_PYO_PAYMENT_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts payment informationfor the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@rep:product AP@rep:lifecycle active@rep:displayname Payment Order/Remittance Advice Payment View@rep:c ,  implementation_dba_data: APPS.ECE_PYO_PAYMENT_V , 

  • View: ECE_DSNO_DELIVERIES_V 12.2.2

    product: EC - e-Commerce Gateway ,  description: No longer used ,  implementation_dba_data: Not implemented in this database , 

  • View: ECE_SPSO_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_SPSO_HEADERS_V,  object_name:ECE_SPSO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Planning Schedule Header View@rep:category BUSINESS_ENTITY CHV_PLANNING ,  implementation_dba_data: APPS.ECE_SPSO_HEADERS_V , 

  • View: ECE_PYO_PAYMENT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_PYO_PAYMENT_V,  object_name:ECE_PYO_PAYMENT_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts payment informationfor the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@rep:product AP@rep:lifecycle active@rep:displayname Payment Order/Remittance Advice Payment View@rep:c ,  implementation_dba_data: APPS.ECE_PYO_PAYMENT_V , 

  • View: ECE_SSSO_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_SSSO_HEADERS_V,  object_name:ECE_SSSO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Shipping Schedule Header View@rep:category BUSINESS_ENTITY CHV_SHIPPING ,  implementation_dba_data: APPS.ECE_SSSO_HEADERS_V , 

  • View: ECE_DSNO_DELIVERIES_V 12.1.1

    product: EC - e-Commerce Gateway ,  description: No longer used ,  implementation_dba_data: Not implemented in this database , 

  • View: ECE_SPSO_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_SPSO_HEADERS_V,  object_name:ECE_SPSO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Planning Schedule Header View@rep:category BUSINESS_ENTITY CHV_PLANNING ,  implementation_dba_data: APPS.ECE_SPSO_HEADERS_V , 

  • View: ECE_POCO_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POCO_HEADERS_V,  object_name:ECE_POCO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Header View@rep:category BUSINESS_ENTITY PO_PU ,  implementation_dba_data: APPS.ECE_POCO_HEADERS_V , 

  • View: ECE_INO_HEADER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_INO_HEADER_V,  object_name:ECE_INO_HEADER_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header View@rep:category BUSINESS_ENTITY AR_INVOICE ,  implementation_dba_data: APPS.ECE_INO_HEADER_V , 

  • View: ECE_INO_HEADER_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_INO_HEADER_V,  object_name:ECE_INO_HEADER_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header View@rep:category BUSINESS_ENTITY AR_INVOICE ,  implementation_dba_data: APPS.ECE_INO_HEADER_V , 

  • View: ECE_CDMO_HEADER_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_CDMO_HEADER_V,  object_name:ECE_CDMO_HEADER_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header View@rep:category BUSINESS_ENTITY AR_CRE ,  implementation_dba_data: APPS.ECE_CDMO_HEADER_V , 

  • View: ECE_CDMO_HEADER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_CDMO_HEADER_V,  object_name:ECE_CDMO_HEADER_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header View@rep:category BUSINESS_ENTITY AR_CRE ,  implementation_dba_data: APPS.ECE_CDMO_HEADER_V ,