Search Results ecx_utl_log_dir

Overview

OKL_STREAMS_RECON_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Oracle Lease and Finance Management (OKL) module. It is declared with AUTHID CURRENT_USER and serves as the internal engine behind the Streams Reconciliation report, which reconciles lease stream data across the OKL and OKC (Contracts Core) schema objects. The package corresponds to the header file OKLRSCRS.pls, last updated in January 2007 (version 120.3, marked "noship"), and is installed under the APPS schema, making its procedures callable from the standard APPS runtime environment while remaining designated as a private, non-public API.

The package provides the procedural logic that queries contract headers, streams, stream elements, stream types, product definitions, and report templates, then formats the results into a report output that can be rendered either as a concurrent program output file or as an XML Publisher report. Its naming convention (the _PVT suffix) indicates that it is intended for internal use by public wrapper packages and concurrent program drivers rather than direct customer invocation.

Key Procedures and Functions

The package documents two procedures:

• recon_qry — Generates the streams reconciliation report. Based on the source comments (authorship attributed to Suresh Gorantla), this procedure executes the core reconciliation query, joining contract and stream data, and writes the formatted results to an output destination. It is the original, non-XML Publisher entry point for the report.
• xml_recon_qry — Produces the same reconciliation report specifically for consumption by Oracle XML Publisher. The package declares report input variables P_CONTRACT_NUMBER (typed to OKC_K_HEADERS_B.CONTRACT_NUMBER) and P_END_DATE, indicating that the XML Publisher report is parameterized by contract number and an end date.

Both procedures rely on shared package-level constants and exception definitions, including the log directory constant G_LOG_DIR, which is set to 'ECX_UTL_LOG_DIR' — the same directory referenced in the user's search term. This constant directs UTL_FILE operations to the e-commerce (ECX) log directory, which is a standard diagnostic output location in EBS.

Tables Accessed

Through APPS synonyms the package references the following objects:

• OKC_K_HEADERS_B — contract header data; the contract number parameter is typed from this table.
• OKC_K_LINES_B and OKC_STATUSES_B — contract line and status information used to qualify the contracts included in the reconciliation.
• OKL_STREAMS, OKL_STRM_ELEMENTS, and OKL_STRM_TYPE_B — the lease stream, stream element, and stream type definition tables that form the reconciliation subject matter.
• OKL_K_HEADERS and OKL_PRODUCTS — lease header and product definition data joined to the contracts.
• OKL_G_REPORTS_GT — a global temporary table used to stage report rows during processing.
• FND_LOOKUP_VALUES — lookup code descriptions used for report labeling.
• PLITBLM — the standard EBS temporary table used with PL/SQL table-based DML operations.
• UTL_FILE — Oracle-supplied package used to write the log and report output, governed by G_LOG_DIR = 'ECX_UTL_LOG_DIR'.

Usage Notes

Because OKL_STREAMS_RECON_PVT is a private package with zero inbound package references, it is not called by other PL/SQL packages. Instead, it is invoked directly by the concurrent program definition that drives the Streams Reconciliation report, either in its classic (recon_qry) or XML Publisher (xml_recon_qry) mode. Administrators and support engineers searching for 'ecx_utl_log_dir' are typically troubleshooting log or output file write errors; the G_LOG_DIR constant indicates the package expects a valid ECX_UTL_LOG_DIR directory object and appropriate UTL_FILE permissions granted to the APPS schema. When diagnosing report failures, verify that the directory exists in FND directories, that the OS-level path is writable, and that the concurrent program is submitted with a valid contract number and end date. Custom code should call the corresponding public wrapper or concurrent program rather than this private package directly, since the PVT designation signals no support for external API calls.