Search Results pn_var_rent_inv_all




Overview
Explore in AI Chat

Overview

The PN_VAR_RENT_INV_ALL table is a core data structure within the Oracle E-Business Suite Property Manager (PN) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for storing the final calculated details of variable rent charges. Variable rent is a common lease component where the payment amount fluctuates based on agreed-upon performance metrics, such as a percentage of sales revenue. This table captures the results of the variable rent calculation engine for a specific billing period and invoice date, effectively holding the invoice-ready line items before they are transferred to the Accounts Receivable module for billing. Its role is critical in the lease management lifecycle, bridging the gap between lease terms definition and financial invoicing.

Key Information Stored

While the provided metadata does not list specific columns, the primary and foreign key relationships define its critical data anchors. The table's primary key is VAR_RENT_INV_ID, a unique identifier for each calculated invoice line. Essential foreign keys include VAR_RENT_ID, which links back to the master variable rent agreement (PN_VAR_RENTS_ALL), and PERIOD_ID, which ties the calculation to a specific time period defined in PN_VAR_PERIODS_ALL. Based on its described purpose, the table would also store calculated monetary amounts (e.g., base variable rent, adjustments), the applicable invoice date, status flags, and references to any applied abatements or payment terms. It acts as the detailed child record to a variable rent period.

Common Use Cases and Queries

The primary use case is generating and auditing variable rent invoices. After a calculation run, data in this table is reviewed before interfacing to Receivables. Common reporting needs include summarizing variable rent charges by property or lease for a given period and drilling into calculation details for dispute resolution. A typical query would join to related master tables to produce an invoice-ready report:

  • Invoice Detail Report: SELECT pvria.var_rent_inv_id, pvra.var_rent_num, pvpa.period_name, pvria.invoice_date, pvria.calculated_amount FROM pn_var_rent_inv_all pvria, pn_var_rents_all pvra, pn_var_periods_all pvpa WHERE pvria.var_rent_id = pvra.var_rent_id AND pvria.period_id = pvpa.period_id AND pvpa.period_name = 'JAN-2024';
  • Data Fix Scenario: Updates to this table are highly sensitive and typically performed via standard APIs. Direct DML should be avoided without guidance from Oracle Support, as it can corrupt the invoicing process and downstream financial integration.

Related Objects

The table maintains integral relationships with several key Property Manager tables, as documented by its foreign keys:

  • PN_VAR_RENTS_ALL: Master table for the variable rent agreement. Joined via PN_VAR_RENT_INV_ALL.VAR_RENT_ID.
  • PN_VAR_PERIODS_ALL: Stores the definition of calculation periods. Joined via PN_VAR_RENT_INV_ALL.PERIOD_ID.
  • PN_VAR_ABATEMENTS_ALL: Stores abatement details applied to a variable rent invoice. PN_VAR_ABATEMENTS_ALL.VAR_RENT_INV_ID is a foreign key referencing this table.
  • PN_PAYMENT_TERMS_ALL: Stores payment term details for the invoice. PN_PAYMENT_TERMS_ALL.VAR_RENT_INV_ID is a foreign key referencing this table.

This structure shows PN_VAR_RENT_INV_ALL is a pivotal hub, receiving definitions from master tables and providing detailed invoice lines to abatement and payment term child tables.