Search Results pn_rec_exp_extr_from_gl_pkg




Overview
Explore in AI Chat

Overview

APPS.PN_REC_EXP_EXTR_FROM_GL_PKG is a PL/SQL package owned by the APPS schema that belongs to the Oracle Property Manager (PN) module of Oracle E-Business Suite. Its principal business function is to extract expense information originating in Oracle General Ledger and transform it into records suitable for Property Manager's recoverable expense processing. In lease accounting and property management, recoverable expenses represent operating costs that a landlord may pass through to tenants according to the terms of a lease. Property Manager must consolidate General Ledger balances, budgets, and account mapping data to compute these recoverable amounts, and this package provides the extraction logic that bridges the two subledgers. The ETRM 12.2.2 metadata classifies the package as an OTHER API, indicating that it is an internal utility rather than a formally published public API. The package status is VALID in the documented environments for both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented package exposes three procedures:

  • EXTRACT_EXPENSE_FROM_GL — The core extraction routine. It reads expense balances and budget information from General Ledger and writes the resulting recoverable expense records into the Property Manager interface table. This procedure encapsulates the primary business logic of the package.
  • PUT_LOG — A logging utility used to record diagnostic or execution messages during the extraction process, supporting troubleshooting and auditability.
  • PUT_LINE — A companion logging/output helper that writes individual formatted lines to the log, typically used alongside PUT_LOG for detailed trace output.

The ETRM metadata does not document explicit parameter lists for these procedures, so parameter signatures should be confirmed against the installed source in the target environment before use.

Tables Accessed

The package references a combination of General Ledger and Property Manager objects, primarily through APPS synonyms:

Usage Notes

PN_REC_EXP_EXTR_FROM_GL_PKG is invoked as part of the recoverable expense extraction flow within Oracle Property Manager. It is typically driven by a concurrent program or an internal Property Manager process rather than being called directly from a form. Because the metadata lists no dependent packages referencing it, it operates as a leaf-level utility invoked by higher-level processing logic. The procedures should not be modified, as the package is owned by APPS and may be overwritten during patching or upgrade. Custom extensions should call the documented logic only after validating signatures in the target instance. Always test extraction behavior thoroughly in a non-production environment before relying on the output in recoverable expense calculations.