Search Results ece_trading_partners_pub




Overview
Explore in AI Chat

Overview

APPS.ECE_TRADING_PARTNERS_PUB is a public PL/SQL package within the Oracle E-Business Suite E-Commerce Gateway (ECE) module, which provides the infrastructure for exchanging business documents with external trading partners. The package encapsulates the logic required to resolve, validate, and compare trading partner address information used during inbound and outbound electronic document processing. In the context of ETRM (Electronic Trading Resource Manager) processing under EBS 12.1.1 and 12.2.2, the package acts as the authoritative source for mapping between a trading partner's ECE configuration records and the corresponding HZ (Trading Community Architecture) party, customer account, site, and location records.

The package is classified as a PUBLIC API and is owned by the APPS schema, with a VALID status in the ETRM metadata repository. It is depended upon by several other ECE and order management components, indicating that it serves as a shared service rather than an application-specific utility.

Key Procedures and Functions

The documented API exposes seven procedures and functions, each addressing a discrete aspect of trading partner address handling:

  • ECE_GET_ADDRESS_WRAPPER — A wrapper routine that orchestrates retrieval of a trading partner address by delegating to the underlying address-resolution logic, providing a simplified entry point for callers.
  • ECE_GET_ADDRESS — The core address retrieval routine that resolves a formatted trading partner address from ECE and TCA data sources.
  • ECE_COMPARE_ADDRESSES — Performs comparison between two address representations, typically used to detect discrepancies or changes between a stored trading partner address and the current address value.
  • SCRUB — Normalizes or cleanses address data prior to comparison or storage, ensuring consistent formatting for matching purposes.
  • GET_TP_ADDRESS — Returns the address associated with a specific trading partner record.
  • GET_TP_ADDRESS_REF — Returns a reference or identifier for the trading partner address, used to link the ECE record to its TCA counterpart.
  • GET_TP_LOCATION_CODE — Retrieves the location code that identifies the trading partner site within the ECE and TCA location structures.

Tables Accessed

The package reads from and writes to a defined set of ECE and TCA tables via APPS synonyms:

Usage Notes

ECE_TRADING_PARTNERS_PUB is typically invoked during ECE transaction processing, particularly when inbound or outbound documents require validation of trading partner addresses. The dependency list shows it is referenced by ECE_RULES_PKG, OE_ACKNOWLEDGMENT_PVT, OE_BULK_CACHE, and RLM_VALIDATEDEMAND_SV, indicating its use in order acknowledgment processing, bulk order cache population, and demand validation for return material authorization flows.

Custom code or extensions that need to resolve a trading partner's address in the same manner as standard ECE processing should call the public procedures rather than querying ECE_TP_HEADERS and the HZ tables directly, ensuring consistent scrubbing, comparison, and reference resolution. The package depends on FND_API, so callers should observe the standard Oracle Application Object Library error-handling conventions when interpreting return statuses.