Search Results ece_tp_headers




The ECE_TP_HEADERS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the E-Commerce Gateway (ECG) module, which facilitates electronic data interchange (EDI) and business-to-business (B2B) transactions. This table stores header-level information for trading partner transactions, serving as a central repository for metadata related to inbound and outbound EDI documents. Below is a detailed technical overview of its structure, purpose, and integration within Oracle EBS.

Purpose and Functional Role

The ECE_TP_HEADERS table acts as a master record for trading partner transactions, capturing essential attributes such as transaction direction (inbound/outbound), document type (e.g., PO, invoice), and processing status. It is tightly integrated with other ECG tables like ECE_TP_DETAILS (for line-level data) and ECE_TRANSACTIONS (for runtime processing). Its primary functions include:
  • Transaction Tracking: Maintains a unique identifier (TRANSACTION_ID) for each EDI document, enabling end-to-end traceability.
  • Status Management: Tracks the lifecycle of transactions via status flags (e.g., "PENDING," "PROCESSED," "ERROR").
  • Trading Partner Metadata: Stores references to trading partner profiles (TP_ID) and document standards (e.g., ANSI X12, EDIFACT).

Key Columns and Data Structure

The table's schema includes columns critical for EDI processing:
  • TRANSACTION_ID: Primary key, often populated by a sequence.
  • TP_ID: Foreign key linking to ECE_TP_PROFILES, identifying the trading partner.
  • DOCUMENT_TYPE: Specifies the EDI document type (e.g., "850" for Purchase Orders).
  • DIRECTION: Indicates whether the transaction is inbound (received) or outbound (sent).
  • STATUS_CODE: Reflects processing state (e.g., "NEW," "FAILED").
  • CREATION_DATE/TIMESTAMP: Audit fields for transaction timestamps.
  • PAYLOAD_REFERENCE: Optional field for external system references.

Integration with Oracle EBS Modules

The table interfaces with multiple EBS modules:
  • Order Management (OM): Outbound POs (850) and inbound ASNs (856) are logged here.
  • Accounts Payable (AP): Inbound invoices (810) are tracked.
  • Inventory (INV): Supports Advanced Shipment Notifications (ASNs).
Workflows and concurrent programs (e.g., "EDI Transaction Processor") rely on this table to route documents to appropriate interfaces.

Technical Considerations

  • Indexing: Typically indexed on TRANSACTION_ID, TP_ID, and STATUS_CODE for performance.
  • Partitioning: In high-volume environments, partitioning by CREATION_DATE may be implemented.
  • Purge Policies: Historical data is often archived via ECG purge utilities to maintain performance.

Customization and Extensions

Organizations may extend the table with custom columns (e.g., ATTRIBUTE1-15) for additional metadata. However, such modifications require careful testing to avoid conflicts with standard ECG processes.

Conclusion

The ECE_TP_HEADERS table is a foundational element of Oracle EBS's EDI framework, enabling seamless B2B integration. Its design ensures transactional integrity, auditability, and scalability, making it indispensable for enterprises leveraging E-Commerce Gateway functionalities. Understanding its structure and relationships is essential for troubleshooting, customization, and performance tuning in EBS environments.

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