Search Results po_distributions_archive




Overview
Explore in AI Chat

Overview

The APPS.ECE_PO_ARCHIVE_PKG package body is a PL/SQL archival utility within the Oracle E-Business Suite EDI/XML Gateway component. Its business function is to move — or copy — purchasing document data from the live transactional tables into their corresponding archive tables, allowing historic purchasing documents to be preserved for auditing, reporting, and compliance purposes while keeping the active transaction tables lean. Although the package is owned by the APPS schema and its name is prefixed with the ECE (e-Commerce Gateway) module, its actual dependencies are entirely on the Oracle Purchasing (PO) schema objects. It is therefore best understood as a Purchasing archival engine that is invoked from the ECE/PO integration layer.

The package operates across the complete purchasing document hierarchy — headers, lines, line locations, distributions, and releases — together with the associated document type definitions. This hierarchical scope ensures that referential integrity is maintained as entire documents (rather than isolated rows) are relocated to the archive tables.

Key Procedures and Functions

The ETRM documentation records a single documented program unit within this package body:

  • PORARCHIVE — the archival routine. Based on its name and the tables it touches, this procedure drives the movement of purchasing document records from the live PO tables into their archive counterparts. It coordinates the header, line, line location, distribution, and release archival steps so that a purchasing document is preserved as a consistent whole. No public parameter list is documented in the ETRM metadata; callers should not assume a parameter signature without verifying the package specification in the target instance.

Because the package body is marked VALID and exposes exactly one documented routine, PORARCHIVE represents the principal entry point for all archival activity performed by this object.

Tables Accessed

The package reads from the live Purchasing tables and writes into their parallel archive tables. The documented dependencies are:

In addition, the dependency list references the PO_CODE_RELEASE_GRP and PO_EDI_INTEGRATION_GRP package groups, plus the SYS STANDARD package, which supplies standard PL/SQL exception and utility routines.

Usage Notes

ECE_PO_ARCHIVE_PKG is an internal, server-side utility rather than a user-facing API. It is not referenced by any other database object, meaning it functions as a top-level call target rather than a shared library routine consumed by other packages. In practice it is invoked from a concurrent program or from custom archival scripts that pass already-identified purchasing documents to be relocated. Typical usage scenarios include periodic housekeeping of historical purchase orders, preparation of data before a purge, and retention of EDI-sourced purchasing documents for audit.

Because the package moves data across eleven related tables, any invocation should be run inside a controlled transaction with appropriate error handling and should be validated against the specific patch level of the instance (12.1.1 or 12.2.2), since the table structures and archival logic may differ. Customizations should call this package only as documented, and DBAs should confirm the package specification before building wrappers around PORARCHIVE.