Search Results pn_distributions_history




Overview
Explore in AI Chat

Overview

The PN_DISTRIBUTIONS_HISTORY table is a core audit and tracking entity within the Oracle E-Business Suite Property Manager (PN) module. It functions as a historical ledger, capturing all modifications made to lease payment distribution records over time. In the context of lease management, distributions define how a single lease payment is allocated across different accounting flexfields (e.g., different expense accounts, properties, or projects). This table ensures a complete, immutable audit trail for financial reporting, compliance, and reconciliation purposes. Its existence is critical for tracing the evolution of a distribution's financial attributes, providing a point-in-time reference for any prior accounting period.

Key Information Stored

While the provided metadata specifies the primary and foreign key structure, the table's purpose implies it stores historical snapshots of data from its parent table, PN_DISTRIBUTIONS_ALL. Key columns typically include a system-generated surrogate primary key (DISTRIBUTION_HISTORY_ID), a foreign key to the original distribution (DISTRIBUTION_ID), and audit columns such as CREATION_DATE, LAST_UPDATE_DATE, and LAST_UPDATED_BY. Crucially, it will hold the historical values of changed distribution attributes—like percentage, amount, account code combination (CODE_COMBINATION_ID), or project association—alongside metadata identifying the specific change event or version number that triggered the historical record creation.

Common Use Cases and Queries

The primary use case is auditing and reporting on changes to lease payment distributions. This is essential for financial audits, resolving accounting discrepancies, and understanding the impact of mid-lease amendments. A common query pattern involves joining to PN_DISTRIBUTIONS_ALL to get the current record and to PN_DISTRIBUTIONS_HISTORY to see prior states. For example, to retrieve the full change history for a specific distribution, one might use: SELECT hist.* FROM pn_distributions_history hist WHERE hist.distribution_id = :dist_id ORDER BY hist.creation_date;. Another critical scenario is generating period-end reports that require the distribution values as they were legally constituted at a specific historical date, ensuring accurate financial statements for past periods.

Related Objects

  • PN_DISTRIBUTIONS_ALL: This is the primary transactional table. PN_DISTRIBUTIONS_HISTORY.DISTRIBUTION_ID is a foreign key referencing this table. Each historical record is a child of a current distribution.
  • PN_PAYMENT_TERMS_HISTORY: This table references PN_DISTRIBUTIONS_HISTORY via its DISTRIBUTION_CHANGE_ID foreign key. This relationship indicates that historical payment term records are linked to the specific distribution change event, creating an integrated audit trail across related lease financial components.