Search Results ece_tp_details




Overview
Explore in AI Chat

Overview

The ECE_TP_DETAILS table is a core data object within the Oracle E-Business Suite e-Commerce Gateway (EC) module. It functions as the central repository for defining and storing the detailed processing rules associated with specific trading partners. In the context of B2B electronic data interchange (EDI), these rules govern how inbound and outbound transaction documents, such as purchase orders or invoices, are parsed, validated, transformed, and routed. The table works in conjunction with the ECE_TP_HEADERS table, forming a parent-child relationship where the header defines the general trading partner setup and the details define the specific, actionable instructions for each transaction type or document standard.

Key Information Stored

The table's primary purpose is to map trading partner transactions to specific E-Commerce Gateway processing components. Its key columns include the surrogate primary key TP_DETAIL_ID and the foreign key TP_HEADER_ID, which links each rule to a parent record in ECE_TP_HEADERS. Other critical columns define the processing workflow: TRANSACTION_TYPE typically identifies the business document (e.g., 850 for a PO), STANDARD_CODE specifies the EDI standard (e.g., X12 or EDIFACT), and VERSION_CODE indicates the standard's version. The table stores references to the application engine programs, maps, and functions responsible for translation, validation, and extraction (columns like EXTRACT_PROGRAM, VALIDATE_PROGRAM, TRANSLATE_PROGRAM). Direction flags indicate whether the rule applies to inbound or outbound processing, enabling the system to apply the correct logic based on document flow.

Common Use Cases and Queries

This table is primarily accessed for configuration, troubleshooting, and auditing trading partner setups. A common operational query involves listing all processing rules for a specific trading partner to verify setup completeness.

  • Sample Query: Rules for a Trading Partner
    SELECT etd.transaction_type, etd.standard_code, etd.direction
    FROM ece_tp_details etd, ece_tp_headers eth
    WHERE eth.tp_header_id = etd.tp_header_id
    AND eth.tp_code = 'TRADING_PARTNER_ABC';
  • Use Case: Integration Debugging: When an inbound EDI document fails, support personnel query this table using the transaction type and standard to identify the assigned validation or translation program for debugging.
  • Use Case: Implementation Reporting: Implementation teams run summary reports to document all configured EDI transactions across partners, often joining with ECE_TP_HEADERS to include the partner name.

Related Objects

The ECE_TP_DETAILS table has a direct, integral relationship with several other e-Commerce Gateway objects. Its primary foreign key constraint links it to ECE_TP_HEADERS (TP_HEADER_ID), establishing the core header-detail model. The processing programs (e.g., EXTRACT_PROGRAM) referenced in its columns are typically Application Engine programs or custom functions defined within the EC module. The table is also fundamentally related to the transaction maps and translation engines that execute the rules it defines. While not a direct foreign key, the data in ECE_TP_DETAILS drives the runtime behavior of the E-Commerce Gateway's inbound and outbound processing engines, which populate interface tables like ECE_PROCESSED_MSGS for logging.

  • 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_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 , 

  • 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_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_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_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_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_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_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_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_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 ,