Search Results pn_distributions_all




Overview
Explore in AI Chat

Overview

The PN_DISTRIBUTIONS_ALL table is a core data repository within the Oracle E-Business Suite Property Manager (PN) module. It serves the critical function of storing the detailed accounting distributions associated with payment terms. These distributions define how the financial obligations of a lease, such as rent or operating expenses, are allocated to specific general ledger accounts. The table operates in a multi-org context, as indicated by the "_ALL" suffix, meaning it stores data for all operating units, with security controlled via the ORG_ID column. Its primary role is to link payment terms, which define the schedule and amount of a payment, to the correct accounting code combinations, ensuring accurate financial posting and reporting for property leases.

Key Information Stored

The table's structure centers on linking distribution records to their parent objects and the general ledger. The primary key, DISTRIBUTION_ID, uniquely identifies each distribution record. The two most critical foreign key columns are PAYMENT_TERM_ID and TERM_TEMPLATE_ID, which link the distribution to either a specific payment term (PN_PAYMENT_TERMS_ALL) or a reusable payment term template (PN_TERM_TEMPLATES_ALL). The ACCOUNT_ID column holds the foreign key to GL_CODE_COMBINATIONS, specifying the exact accounting flexfield to be charged. Other significant columns typically include PERCENTAGE or AMOUNT to define the allocation share, ORG_ID for multi-org partitioning, and standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

This table is central to financial reporting and audit trails for lease accounting. A common use case is generating a report of all accounting distributions for a specific lease payment term to verify correct account coding. Another scenario involves querying distributions to analyze expense allocation across different cost centers. A typical analytical query would join to payment terms and the general ledger to review account assignments:

  • SELECT pt.name term_name, d.percentage, gcc.segment1, gcc.segment2 FROM pn_distributions_all d, pn_payment_terms_all pt, gl_code_combinations gcc WHERE d.payment_term_id = pt.payment_term_id AND d.account_id = gcc.code_combination_id AND pt.lease_id = &lease_id;

The table is also essential for the creation of accrual and invoice distributions within the Property Manager's billing engine.

Related Objects

PN_DISTRIBUTIONS_ALL maintains integral relationships with several key Property Manager and General Ledger tables, as documented in the ETRM metadata. The primary foreign key dependencies, where this table references others, are:

  • GL_CODE_COMBINATIONS: Joined via PN_DISTRIBUTIONS_ALL.ACCOUNT_ID to obtain the accounting flexfield details.
  • PN_PAYMENT_TERMS_ALL: Joined via PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID to link distributions to active payment terms for a lease.
  • PN_TERM_TEMPLATES_ALL: Joined via PN_DISTRIBUTIONS_ALL.TERM_TEMPLATE_ID to link distributions to template-defined payment terms.

The primary table that references PN_DISTRIBUTIONS_ALL is:

  • PN_DISTRIBUTIONS_HISTORY: References PN_DISTRIBUTIONS_ALL.DISTRIBUTION_ID, creating an audit trail for changes made to distribution records over time.