Search Results pn_rec_agreements_all




Overview
Explore in AI Chat

Overview

The PN_REC_AGREEMENTS_ALL table is a core setup entity within Oracle E-Business Suite Property Manager (PN). It serves as the master repository for defining and storing recovery agreements. These agreements are contractual frameworks that govern the billing and recovery of property-related operating expenses, such as common area maintenance (CAM), utilities, taxes, and insurance, from tenants. The table's role is to establish the foundational relationship between a lease, a property, and a customer, enabling the systematic calculation, billing, and tracking of recoverable costs throughout the lease term. Its multi-org structure, indicated by the `ALL` suffix and the ORG_ID column, supports implementation across multiple business units.

Key Information Stored

The table's primary key is REC_AGREEMENT_ID, which uniquely identifies each recovery agreement. Essential foreign key columns define its critical business relationships: LEASE_ID links to PN_LEASES_ALL, PROPERTY_ID to PN_PROPERTIES_ALL, and CUSTOMER_ID to HZ_PARTIES or HZ_CUST_ACCOUNTS, anchoring the agreement to a specific tenant. The CUST_SITE_ID links to HZ_CUST_SITE_USES_ALL, identifying the bill-to location. The TERM_TEMPLATE_ID references PN_TERM_TEMPLATES_ALL, which dictates the calculation and billing frequency. Other significant columns typically include agreement dates, status, calculation methods, and descriptive information that controls the recovery process.

Common Use Cases and Queries

This table is central to operational and financial reporting in Property Manager. Common use cases include generating tenant recovery statements, auditing recovery billings, and analyzing portfolio recovery income. A fundamental query retrieves all active recovery agreements for a specific property or lease to review setup. For reporting, it is frequently joined to lease, customer, and period billing tables. A typical SQL pattern to list agreements with core details is:

  • SELECT pra.REC_AGREEMENT_ID, pla.LEASE_NUM, hca.ACCOUNT_NUMBER, ppa.PROPERTY_NAME, pra.STATUS
  • FROM PN_REC_AGREEMENTS_ALL pra,
  • PN_LEASES_ALL pla,
  • HZ_CUST_ACCOUNTS hca,
  • PN_PROPERTIES_ALL ppa
  • WHERE pra.LEASE_ID = pla.LEASE_ID
  • AND pra.CUSTOMER_ID = hca.CUST_ACCOUNT_ID
  • AND pra.PROPERTY_ID = ppa.PROPERTY_ID
  • AND pra.ORG_ID = :org_id;

Related Objects

PN_REC_AGREEMENTS_ALL has extensive relationships within the Property Manager schema, acting as a parent to several transactional and calculation tables. The documented foreign key relationships are:

  • Parent Tables (Foreign Key References from PN_REC_AGREEMENTS_ALL):
    • PN_LEASES_ALL via LEASE_ID
    • PN_PROPERTIES_ALL via PROPERTY_ID
    • HR_ALL_ORGANIZATION_UNITS via ORG_ID
    • HZ_PARTIES and HZ_CUST_ACCOUNTS via CUSTOMER_ID
    • PN_TERM_TEMPLATES_ALL via TERM_TEMPLATE_ID
    • HZ_CUST_SITE_USES_ALL via CUST_SITE_ID
  • Child Tables (Foreign Key References to PN_REC_AGREEMENTS_ALL.REC_AGREEMENT_ID):