Search Results pn_index_history_lines




Overview
Explore in AI Chat

Overview

The PN_INDEX_HISTORY_LINES table is a core data structure within the Property Manager (PN) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the detailed repository for index values used in lease agreements. In property management, lease payments are often tied to a financial index (e.g., Consumer Price Index) and subject to periodic adjustments. This table stores the historical time-series data for these indices, enabling the system to calculate accurate rent escalations by referencing the correct index value applicable for a specific date. Its role is critical for the automated processing of lease indexation, ensuring financial calculations are auditable and based on a definitive history of index rates.

Key Information Stored

The table's primary purpose is to store discrete index entries, each identified by a unique INDEX_LINE_ID. While the full column list is not detailed in the provided excerpt, the description and foreign key relationships indicate it must contain, at minimum, the index identifier (INDEX_ID, linking to PN_INDEX_HISTORY_HEADERS), an effective date for the index value, and the numerical index value itself. Additional columns likely track creation date, last update date, and the user responsible for the entry, supporting audit trails. The INDEX_LINE_ID serves as the primary key for the table and is the critical reference point for other leasing tables to pinpoint a specific index snapshot in time.

Common Use Cases and Queries

The primary use case is supporting rent review and escalation processes. When a lease period requires index-based adjustment, the system queries this table to find the index value effective on the lease's base date and the current review date. A common reporting need is to generate a history of all values for a specific index type for analytical purposes. Sample SQL patterns include retrieving the latest index value for a lease or comparing values between two dates:

  • Finding the applicable index line for a lease's base index: SELECT * FROM pn_index_history_lines WHERE index_line_id = (SELECT base_index_line_id FROM pn_index_leases_all WHERE lease_id = :p_lease_id);
  • Generating a full history for an index: SELECT index_date, index_value FROM pn_index_history_lines WHERE index_id = :p_index_id ORDER BY index_date;

Related Objects

PN_INDEX_HISTORY_LINES is centrally connected to several key Property Manager tables, as documented by its foreign key relationships:

  • PN_INDEX_HISTORY_HEADERS: The parent table. PN_INDEX_HISTORY_LINES.INDEX_ID is a foreign key to this table, defining the type of index (e.g., CPI, PPI) to which the line's value belongs.
  • PN_INDEX_LEASES_ALL: A lease is associated with a base index value. The column PN_INDEX_LEASES_ALL.BASE_INDEX_LINE_ID is a foreign key referencing INDEX_LINE_ID, establishing the starting index point for that lease's calculations.
  • PN_INDEX_LEASE_PERIODS_ALL: Tracks indexation for specific lease periods. It references PN_INDEX_HISTORY_LINES twice: via CURRENT_INDEX_LINE_ID (the index value at the period's end) and PREVIOUS_INDEX_LINE_ID (the index value at the period's start), enabling the precise calculation of the change factor for the period.