Search Results pn_var_rents_all

Overview

The PN_VAR_RENTS_ALL table is a core data object within the Property Manager (PN) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for variable rent agreement definitions. In commercial property management, variable rent, often referred to as percentage rent, is a lease component where the rent amount fluctuates based on a tenant's sales performance or other agreed-upon metrics. This table stores the foundational header-level information that defines the rules, terms, and structure of these complex rental calculations, enabling the system to generate accurate and periodic variable rent invoices.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key and foreign key relationships indicate the critical data it contains. The primary identifier is the VAR_RENT_ID, a unique system-generated key for each variable rent agreement. Two crucial foreign keys define its core relationships: LEASE_ID links the variable rent terms to a specific lease contract in the PN_LEASES_ALL table, and TERM_TEMPLATE_ID references a predefined calculation template in PN_TERM_TEMPLATES_ALL. The table likely also stores attributes such as the agreement's effective dates, calculation frequency (e.g., monthly, quarterly), status, and control flags that govern the invoicing and reconciliation processes for the variable rent component.

Common Use Cases and Queries

This table is central to all variable rent processing. Common use cases include generating periodic rent invoices, performing sales data uploads and reconciliations, and auditing rent calculation histories. For reporting and data extraction, a typical query would join this header table to its related detail tables and the lease master. A fundamental SQL pattern to retrieve active variable rent agreements for a specific lease would be:

• SELECT pvr.* FROM pn.pn_var_rents_all pvr WHERE pvr.lease_id = <lease_id> AND pvr.status = 'ACTIVE';

Technical consultants and business analysts frequently query this table to troubleshoot calculation issues, validate setup, and create custom reports that summarize variable rent liabilities or income across a property portfolio.

Related Objects

The PN_VAR_RENTS_ALL table has extensive relationships within the Property Manager schema, acting as a parent to numerous detail tables. As documented in the metadata, the following objects have a foreign key dependency on PN_VAR_RENTS_ALL.VAR_RENT_ID:

• PN_VAR_ABATEMENTS_ALL: Stores rent abatement details for the agreement.
• PN_VAR_BKPTS_DET_ALL & PN_VAR_BKPTS_HEAD_ALL: Store breakpoint details and headers used in tiered rent calculations.
• PN_VAR_GRP_DATES_ALL: Holds grouping dates for calculation periods.
• PN_VAR_LINES_ALL: Contains the specific lines that define sales types, breakpoints, and percentages.
• PN_VAR_PERIODS_ALL: Stores the calculated periods and results for the variable rent.
• PN_VAR_RENT_DATES_ALL: Manages key dates for the agreement cycle.
• PN_VAR_RENT_INV_ALL: Holds the generated invoice lines for variable rent.
• PN_VAR_RENT_SUMM_ALL: Stores summary-level information for reporting.

Furthermore, it is a child table referencing PN_LEASES_ALL via LEASE_ID and PN_TERM_TEMPLATES_ALL via TERM_TEMPLATE_ID, establishing its place in the broader lease hierarchy.