Results for “pn_distributions_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PN_DISTRIBUTIONS_ALL is the foundational distribution table within the Oracle E-Business Suite (EBS) Property Manager (PN) module. It records the accounting distributions associated with payment terms, defining how payment amounts are allocated across general ledger accounts, account classes, and percentage splits. This table is central to the property management subledger, where lease payment terms must be broken into distributable components before they can be posted to the General Ledger or reported against tenant financial obligations.

The table resides in the PN schema and is classified as VALID in the documented ETRM metadata for releases 12.1.1 and 12.2.2. Its documented description is straightforward: it stores distributions for a payment term. In practice this means each row represents a single distribution line tied to a payment term or term template, with an account assignment and a percentage share of the associated obligation.

Under a heuristic Data Vault classification, PN_DISTRIBUTIONS_ALL leans toward the satellite category. It carries descriptive and foreign-key attributes that hang off business keys defined in the payment term and term template tables, which is characteristic of a satellite entity dependent on parent keys rather than a standalone hub or an associative link.

Key Information Stored

The documented physical schema contains 29 columns. The most significant are summarized below.

• DISTRIBUTION_ID — The surrogate primary key, enforced by the PN_DISTRIBUTIONS_PK constraint. It is also the sole business-key candidate, backed by the unique index PN_DISTRIBUTIONS_U1.
• PAYMENT_TERM_ID — Foreign key identifying the parent payment term in PN_PAYMENT_TERMS_ALL. This is the primary business association for the distribution.
• TERM_TEMPLATE_ID — Foreign key to PN_TERM_TEMPLATES_ALL, linking the distribution to a reusable term template where applicable.
• ACCOUNT_ID — Foreign key to GL_CODE_COMBINATIONS, supplying the accounting flexfield for the distribution line.
• ACCOUNT_CLASS — Classifies the distribution account, supporting categorization of receivable, revenue, or similar ledger purposes.
• PERCENTAGE — The proportional share assigned to the distribution, typically summing to 100 percent across the lines of a term.
• LINE_NUMBER — Orders the distribution lines within the parent term.
• ORG_ID — The operating unit identifier enabling multi-org partitioning of property management data.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and modified each row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns available for client-specific extension.

Common Use Cases and Queries

The most frequent practical requirement is to retrieve all distributions for a given payment term, resolving the account flexfield for reporting.

SELECT d.distribution_id, d.line_number, d.percentage, g.segment1, g.segment2 FROM pn_distributions_all d, gl_code_combinations g WHERE d.account_id = g.code_combination_id AND d.payment_term_id = :term_id ORDER BY d.line_number;

Other common scenarios include validating that percentages sum to 100 for each term, reconciling distributions against PN_DISTRIBUTIONS_HISTORY, and joining to PN_TERM_TEMPLATES_ALL to report standardization across lease agreements. Reporting extracts often join PN_PAYMENT_TERMS_ALL to obtain term details, and ORG_ID is applied as a mandatory filter in multi-org environments.

Related Objects

• PN_PAYMENT_TERMS_ALL — Parent table joined on PAYMENT_TERM_ID; defines the term to which distributions belong.
• PN_TERM_TEMPLATES_ALL — Joined on TERM_TEMPLATE_ID; supplies reusable distribution templates.
• GL_CODE_COMBINATIONS — Joined on ACCOUNT_ID; provides the accounting flexfield values.
• PN_DISTRIBUTIONS_HISTORY — Child history table joined on DISTRIBUTION_ID; stores the audit trail of distribution changes.