Search Results payment term




The PN_DISTRIBUTIONS_ALL table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical data structure within the Property Manager (PN) module, primarily responsible for storing distribution-level details of lease payments, expenses, and other financial transactions. This table serves as a junction between lease agreements, accounting entries, and financial reporting, ensuring accurate cost allocation across departments, projects, or other analytical dimensions. Below is a detailed technical and functional breakdown of this table.

Table Overview

PN_DISTRIBUTIONS_ALL is a multi-organization-enabled table, meaning it stores data for all operating units (as indicated by the _ALL suffix). It is part of the Property Manager schema and integrates with Oracle General Ledger (GL), Accounts Payable (AP), and other financial modules. The table captures distribution lines generated from lease payment schedules, expense allocations, or manual adjustments, enabling granular tracking of financial obligations.

Key Columns and Their Significance

1. DISTRIBUTION_ID: Primary key uniquely identifying each distribution line.
2. LEASE_ID: Foreign key linking to PN_LEASES_ALL, associating the distribution with a lease agreement.
3. PAYMENT_TERM_ID: References PN_PAYMENT_TERMS_ALL, tying the distribution to a payment schedule.
4. ACCOUNT_ID: GL account code for posting the distribution.
5. AMOUNT: The monetary value of the distribution, in functional currency.
6. PERIOD_ID: Accounting period identifier for GL reconciliation.
7. PROJECT_ID: Optional field for Project Accounting integration.
8. ORG_ID: Operating unit identifier for multi-org support.
9. STATUS: Indicates lifecycle states (e.g., "DRAFT," "POSTED," "CANCELLED").
10. DISTRIBUTION_TYPE: Classifies the line as "RENT," "EXPENSE," "TAX," etc.

Functional Role in Lease Management

The table enables:

  • Cost Allocation: Splits lease payments across multiple departments or GL accounts.
  • Accrual Accounting: Supports period-end accruals by storing unposted distributions.
  • Audit Compliance: Provides a traceable record of financial transactions tied to leases.
  • Integration with AP/GL: Distributes invoice lines (AP_INVOICE_DISTRIBUTIONS_ALL) and journal entries (GL_JE_LINES).

Technical Dependencies

PN_DISTRIBUTIONS_ALL interacts with:

  • PN_LEASE_DETAILS_ALL: For lease terms affecting distributions.
  • PN_PAYMENT_ITEMS_ALL: For payment-level attributes.
  • GL_CODE_COMBINATIONS: Validates accounting flexfields.
  • AP_INVOICES_ALL: For vendor invoice linkages.
Indexes on LEASE_ID, PAYMENT_TERM_ID, and ORG_ID optimize query performance.

Customization Considerations

Common extensions include:

  • Adding descriptive flexfields (DFFs) for industry-specific attributes.
  • Creating triggers to enforce business rules (e.g., minimum distribution amounts).
  • Developing APIs to automate bulk distribution generation.

Data Flow Example

1. A lease payment schedule generates distributions via PN_PAYMENT_TERMS_ALL.
2. During invoice processing, distributions are validated against GL accounts.
3. Upon approval, status updates to "POSTED," and GL journals are created.
4. Reports leverage the table for expense analysis by cost center or lease.

Conclusion

The PN_DISTRIBUTIONS_ALL table is a cornerstone of Oracle Property Manager, bridging lease contracts, financial systems, and reporting. Its design ensures compliance with accounting standards while offering flexibility for complex allocation scenarios. Understanding its structure is essential for troubleshooting, customization, and optimizing lease-related financial processes in Oracle EBS.