Search Results create_retro_adjustments




Overview
Explore in AI Chat

Overview

PN_RETRO_ADJUSTMENT_PKG is a PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Property Manager (ETRM) module. Its business purpose is to process retroactive adjustments arising from lease changes — most commonly index-based rent escalations, renegotiated payment terms, or other lease modifications that alter previously scheduled rent amounts and therefore require recalculating historical periods. When a lease term, rate, or payment schedule changes after payments have already been scheduled or accounted for, the affected prior periods must be adjusted so that the lease's financial records reflect the corrected values. This package performs that retroactive recalculation, comparing the changed lease terms against the existing payment schedules, generating adjustment entries to reconcile the difference, and creating virtual schedules used to compute the adjustment amounts before they are finalized.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents four procedures within the package:

  • CREATE_RETRO_ADJUSTMENTS — The primary driver procedure. It identifies leases affected by a change and generates the retroactive adjustment records, populating the adjustment summaries and details tables that record how much each prior period must be adjusted.
  • FIND_SCHEDULE — Locates the applicable payment schedule (or schedules) for a lease so that the adjustment logic can compare the "as-was" scheduled amounts against the corrected calculation.
  • CREATE_VIRTUAL_SCHEDULES — Builds temporary or in-memory schedule representations used to compute what the payment schedule should have been under the changed terms, without immediately persisting them as live schedule rows.
  • CLEANUP_SCHEDULES — Removes the intermediate virtual schedule data once the adjustment calculation is complete, preventing orphaned or duplicate schedule records from affecting subsequent processing.

The procedures operate as a coordinated sequence: locate the existing schedule, construct a comparison schedule, compute adjustments, and clean up.

Tables Accessed

The package reads and writes a range of Property Manager tables. Lease-level data is drawn from PN_LEASES, PN_LEASES_ALL, and PN_LEASE_CHANGES, which supply the attributes that drive recalculation. Payment data is read from and written to PN_PAYMENT_SCHEDULES, PN_PAYMENT_SCHEDULES_ALL, PN_PAYMENT_ITEMS, PN_PAYMENT_ITEMS_ALL, and PN_PAYMENT_ITEMS_S. Payment term definitions and history are read from PN_PAYMENT_TERMS, PN_PAYMENT_TERMS_ALL, and PN_PAYMENT_TERMS_HISTORY. The adjustment results are persisted in PN_ADJUSTMENT_SUMMARIES, PN_ADJUSTMENT_SUMMARIES_S, PN_ADJUSTMENT_DETAILS, and PN_ADJUSTMENT_DETAILS_S. All access is through APPS synonyms, with the underscore_S variants denoting the audit/shadow tables maintained by Oracle's table-handling framework.

Usage Notes

PN_RETRO_ADJUSTMENT_PKG is an internal, non-API package rather than a public integration interface, and it is not intended for direct invocation by customers or third-party applications. It is typically called indirectly: the ETRM indexation and lease-change flows invoke it when processing rent adjustments, and the metadata shows it is referenced by PN_INDEX_RENT_PERIODS_PKG and PN_SCHEDULES_ITEMS, indicating it is driven by the index rent and schedule item logic. Operators may trigger retroactive adjustment processing through the Property Manager lease-change or indexation concurrent programs, which in turn call this package. Because it manipulates core lease and payment schedule tables directly, it should only be invoked through supported ETRM processes; custom code bypassing the standard flows risks inconsistent schedules and adjustment summaries.