Search Results purge_interface_tables

Overview

OKL_PURGE_STRM_INTF_PVT is a private (PVT-classified) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owned by the APPS schema. Its singular business purpose is to purge stale records from the Streams interface tables used by the OKL Streams integration. As the source header ($Header: OKLRPSIB.pls) and the API name constant PURGE_INTERFACE_TABLES indicate, the package provides a controlled housekeeping mechanism that removes legacy staging rows no longer required by the Streams processing or downstream accounting flows. Because the package is classified as private, Oracle does not expose it as a supported public API; it exists to service internal ETRM processing and purge routines.

Key Procedures and Functions

The package body contains exactly one documented procedure:

• PURGE_INTERFACE_TABLES — the sole entry point of the package. It accepts a caller-supplied end date parameter (internally converted via fnd_date.canonical_to_date) that defines the cutoff for deletion: interface records with a creation date earlier than the specified end date are removed. The procedure is structured as a concurrent-program style interface, returning x_errbuf and x_retcode OUT parameters, and initializes the standard OKL API framework variables (including l_api_name, l_api_version, and OKL_API.G_RET_STS_SUCCESS). It writes progress and diagnostic messages to the concurrent manager log via FND_FILE.Put_Line, reporting the cutoff date applied and each interface table purged. The declared record-type variables (sifv, sitv, sfev, silv, sxpv, siyv, sirv, srsv, srlv, srmv) indicate the procedure iterates over the Streams interface entity structures. Note that the parallel DML/query ALTER SESSION statements are commented out in the shipped source.

No other procedures or functions are documented in this package.

Tables Accessed

The package deletes from, or otherwise references, the following interface tables using APPS synonyms:

• OKL_SIF_FEES, OKL_SIF_LINES, OKL_SIF_PRICING_PARAMS, OKL_SIF_RETS, OKL_SIF_RET_ERRORS, OKL_SIF_RET_LEVELS, OKL_SIF_RET_STRMS, OKL_SIF_STREAM_TYPES, OKL_SIF_TRX_PARMS, OKL_SIF_YIELDS — the primary Streams interface (SIF) staging tables holding fees, lines, pricing parameters, returns, errors, levels, stream types, transaction parameters, and yield data.
• OKL_STREAM_INTERFACES and OKL_STREAM_TRX_DATA — higher-level Streams interface and transaction data tables.

These are transient staging structures; the purge removes rows whose creation date precedes the run date, preventing unbounded growth of interface data after successful processing into the core OKL tables.

Usage Notes

Given its PVT classification and its errbuf/retcode signature, OKL_PURGE_STRM_INTF_PVT.PURGE_INTERFACE_TABLES is intended to be invoked from an Oracle Concurrent Program registered in the Lease and Finance Management responsibility, rather than called directly by forms or custom code. The presence of FND_FILE.Put_Line logging and the standard concurrent return parameters confirms this execution model. Administrators or support personnel run the associated "Streams Interface Tables purge concurrent program" (as the log message names it) to clean up the OKL_SIF_* and OKL_STREAM_* interface tables after Streams data has been processed, supplying an end date to limit the deletion scope. Because it is not referenced by any other package in the documented metadata, it is effectively a standalone maintenance utility. Customers should treat it as an internal, unsupported API and rely on the registered concurrent program rather than direct invocation in custom code.