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
TheECE_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).
Technical Considerations
- Indexing: Typically indexed on
TRANSACTION_ID
,TP_ID
, andSTATUS_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
TheECE_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 ,
-
APPS.EC_INBOUND_STAGE dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.EC_INBOUND_STAGE dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.EC_INBOUND_STAGE dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.EC_INBOUND_STAGE dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.WSH_TPA_SELECTOR_PKG dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.WSH_DSNO dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_FORECAST_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_SETUP_TERMS_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_RD_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.ECE_AP_PAYMENT dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.RLM_MANAGE_DEMAND_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.CHV_BUILD_SCHEDULES dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.CHV_BUILD_SCHEDULES dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_BLANKET_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.EC_TRADING_PARTNER_PVT dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.WSH_ECE_VIEWS_DEF dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_EXTINTERFACE_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_BLANKET_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.RLM_VALIDATEDEMAND_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.RLM_EXTINTERFACE_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.RLM_MANAGE_DEMAND_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.ECE_CDMO_UTIL dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.WSH_ECE_VIEWS_DEF dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.RLM_FORECAST_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.ECE_TRADING_PARTNERS_PUB dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.RLM_CUM_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.IBY_PYO_TRANSACTION dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.ECE_CDMO_UTIL dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.WSH_TPA_SELECTOR_PKG dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_CUM_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.ECE_TRADING_PARTNERS_PUB dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_VALIDATEDEMAND_SV dependencies on ECE_TP_HEADERS
12.1.1
-
APPS.RLM_RD_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.RLM_SETUP_TERMS_SV dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.WSH_DSNO dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.EC_TRADING_PARTNER_PVT dependencies on ECE_TP_HEADERS
12.2.2
-
APPS.EC_INBOUND_STAGE dependencies on ECE_TP_DETAILS
12.1.1
-
APPS.EC_INBOUND_STAGE dependencies on ECE_TP_DETAILS
12.2.2
-
APPS.EC_TRADING_PARTNER_PVT dependencies on PO_VENDOR_SITES
12.1.1
-
APPS.EC_TRADING_PARTNER_PVT SQL Statements
12.1.1
-
APPS.EC_TRADING_PARTNER_PVT SQL Statements
12.2.2
-
APPS.EC_TRADING_PARTNER_PVT dependencies on PO_VENDOR_SITES
12.2.2
-
APPS.EC_TRADING_PARTNER_PVT dependencies on PO_VENDORS
12.1.1
-
APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_CUSTOMER_LOCATIONS_V
12.1.1
-
APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_CUSTOMER_LOCATIONS_V
12.2.2
-
APPS.ECE_TRADING_PARTNERS_PUB dependencies on PO_VENDOR_SITES
12.2.2