Search Results edr_evidence_store

Overview

EDR_TRANS_ACKN_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, part of the EDR (Electronic Data Records / eRecords) module known commercially as Oracle EDR or the E-Records and Transaction Acknowledgement framework. Its primary business purpose is to manage the transmission of transaction acknowledgements between trading partners and internal systems. In regulated, process-manufacturing and supply-chain environments, transaction acknowledgements confirm that a discrete business document — such as a purchase order, shipment notice, or quality result — has been received, accepted, or rejected by the intended recipient. The EDR_TRANS_ACKN_PUB package provides the outgoing side of that acknowledgement conversation, allowing calling applications to signal receipt or acknowledgment status for a given transaction record. The package is classified as a PUB (public) API, meaning it is intended for external invocation by other application modules and by supported customizations rather than being restricted to internal implementation use.

Key Procedures and Functions

The documented public interface of EDR_TRANS_ACKN_PUB exposes a single entry point:

• SEND_ACKN — The procedure responsible for sending an acknowledgement for a transaction. It creates or updates the acknowledgement record and dispatches it through the EDR acknowledgement mechanism. As a PUB-classified routine, it is the supported integration point for programs that need to confirm the status of an electronic transaction.

The metadata records only one documented procedure, so no additional public routines are asserted here. Parameter lists are intentionally omitted because they are not documented in the supplied metadata; consultants should inspect the package specification in the database for the exact signature before building custom calls.

Tables Accessed

• EDR_TRANS_ACKN — The principal and only documented table accessed by this package, reached through an APPS synonym. This table stores acknowledgement records for transactions. SEND_ACKN reads from and writes to this table to persist the acknowledgement state and to associate it with the originating transaction.

No other base tables are documented as directly referenced. The package also declares a dependency on SYS.STANDARD, the standard PL/SQL package always present in every compiled package.

Usage Notes

EDR_TRANS_ACKN_PUB is referenced by six other application packages, indicating its role as a shared service rather than a leaf module: CS_ERES_INT_PKG, EDR_FILES_PUB, EDR_TRANS_ACKN_PUB itself, GMD_EDR_STANDARD, PO_ERECORDS_PVT, and QA_EDR_STANDARD. This dependency pattern shows that acknowledgement logic is reused across customer service, process manufacturing (GMD), purchasing (PO eRecords), and quality (QA) flows. The package is typically invoked programmatically — from concurrent programs, workflow, or integration code — at the moment a transaction requires acknowledgment, rather than from an end-user form. Because it is classified PUB, it is the correct target for custom code that must trigger or re-send acknowledgements, whereas callers should avoid the internal package body routines. When customizing, verify parameter signatures and initialization requirements against the 12.1.1 or 12.2.2 specification, as the metadata documented here provides no explicit argument detail.