Search Results ece_tp_details_pk

Overview

In Oracle E-Business Suite, the table EC.ECE_TP_DETAILS is a core component of the e-Commerce Gateway (EC) module. It stores the trading partner processing rules that govern how inbound and outbound electronic documents are translated, mapped, and routed for a specific trading partner. Each row represents a distinct processing rule or document mapping associated with a trading partner header record, enabling the gateway to apply the correct standard, translator, and map configuration per partner and per document type.

The table is owned by the EC schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. It carries 26 physical columns and is referenced throughout the EDI document processing pipeline.

From a Data Vault modeling perspective, the mined FK structure places ECE_TP_DETAILS as satellite-leaning. Its primary foreign key dependency — TP_HEADER_ID referencing ECE_TP_HEADERS — indicates it functions as a dependent detail (satellite) attached to the trading partner header hub rather than as an independent hub or an associative link.

Key Information Stored

The primary key is enforced by ECE_TP_DETAILS_PK on the surrogate column TP_DETAIL_ID. A secondary unique index, ECE_TP_DETAILS_U2, acts as the business-key candidate on the composite of TP_HEADER_ID, DOCUMENT_ID, and DOCUMENT_TYPE, guaranteeing one processing rule per partner per document. A redundant unique index, ECE_TP_DETAILS_U1, also exists on TP_DETAIL_ID.

• TP_DETAIL_ID — Surrogate primary key uniquely identifying each processing rule row.
• TP_HEADER_ID — Foreign key to ECE_TP_HEADERS, tying the rule to a trading partner header.
• DOCUMENT_ID / DOCUMENT_TYPE — Identify the EDI document the rule applies to; jointly form the business key with the header.
• TRANSLATOR_CODE — Specifies the translation engine or translator to apply.
• DOCUMENT_STANDARD — Denotes the EDI standard (e.g., ANSI X12, EDIFACT) in effect.
• MAP_ID — Reference to the mapping definition used to convert the document.
• EDI_FLAG, PRINT_FLAG, TEST_FLAG — Control flags governing electronic transmission, printing, and test-mode handling.
• ORG_ID — Operating unit context for multi-org security and reporting.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Concurrent program audit columns identifying the job that last modified the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–5 — Descriptive flexfield segments for extensibility.

Common Use Cases and Queries

Administrators and developers query this table to audit and troubleshoot trading partner configuration. Typical scenarios include verifying which translator or map is applied to a document, confirming test versus production flags, and generating configuration reports for a given operating unit.

Retrieving all processing rules for a trading partner:

SELECT tp_detail_id, document_id, document_type, translator_code,
       document_standard, map_id, edi_flag, print_flag, test_flag
FROM   ec.ece_tp_details
WHERE  tp_header_id = :tp_header_id;

Joining to headers to report partner-level configuration:

SELECT h.tp_header_id, h.trading_partner_id, d.document_type,
       d.document_standard, d.map_id
FROM   ec.ece_tp_headers h, ec.ece_tp_details d
WHERE  h.tp_header_id = d.tp_header_id
AND    d.org_id = :org_id;

Locating rules that are configured in test mode:

SELECT tp_detail_id, tp_header_id, document_type
FROM   ec.ece_tp_details
WHERE  test_flag = 'Y';

Related Objects

• ECE_TP_HEADERS — Parent table; joined via ECE_TP_DETAILS.TP_HEADER_ID = ECE_TP_HEADERS.TP_HEADER_ID.
• ECE_TP_HEADERS_PK — Primary key of the parent header, driving the FK relationship.
• ECE_TP_DETAILS_PK — Primary key index on TP_DETAIL_ID.
• ECE_TP_DETAILS_U2 — Unique business-key index on (TP_HEADER_ID, DOCUMENT_ID, DOCUMENT_TYPE).
• ECE_TP_DETAILS_U1 — Redundant unique index on TP_DETAIL_ID.
• Concurrent programs identified through REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID that maintain gateway configuration.