Results for “diff_var_rent”

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

Overview

PN_VAR_PERIODS_V is a form view owned by the APPS schema in Oracle E-Business Suite, classified under the PN (Property Manager) product family. Its documented purpose is to display generated periods for a variable rent agreement. In the Property Manager module, variable rent agreements differ from fixed rent agreements in that the rent amount is calculated or accumulated across discrete periods rather than being stated as a single contractual figure. This view serves as the presentation layer that surfaces each generated period alongside the actual invoiced variable rent, the forecast variable rent, and the variance between the two.

Because the object is a view rather than a table, it stores no data of its own. It is a read-only construct executed at query time, which means it always reflects the current state of the underlying transaction tables. This makes it suitable for form-based inquiry, reporting, and integration extracts where up-to-date period balances are required. The view is documented as VALID and is referenced by the Property Manager forms that manage variable rent agreements.

Underlying Base Objects

The documented ETRM metadata for release 12.2.2 lists the following referenced base objects: PN_VAR_PERIODS (synonym), PN_VAR_PERIODS_ALL (synonym), PN_VAR_RENTS_ALL (synonym), PN_VAR_RENT_CALC_PKG (package), and PN_VAR_RENT_INV_ALL (synonym). The view text joins these objects to assemble a period-level result set.

The primary driving table is PN_VAR_PERIODS (alias PER), which supplies the period identity, period number, date range, descriptive attributes, and organization identifier. PN_VAR_RENTS_ALL (alias VARENT) is joined on VAR_RENT_ID to confirm the parent variable rent agreement. A derived inline summary subquery aggregates PN_VAR_RENT_INV_ALL (alias VSUMM) grouped by PERIOD_ID and VAR_RENT_ID, producing actual and forecast rent totals; this summary is outer-joined back to the period rows so that periods without invoiced activity still appear. PN_VAR_RENT_CALC_PKG is the calculation package responsible for generating period records and computing variable rent amounts, and it is the process that populates the rows the view later reads. Note that the view references PN_VAR_PERIODS_ALL within the inline subquery and PN_VAR_PERIODS at the outer level, reflecting the standard EBS pattern of an _ALL table for multi-organization data and a non-suffixed synonym for the operating view.

Key Columns

• ROW_ID — the ROWID of the underlying period row, used by Oracle Forms for row identification and locking semantics.
• PERIOD_ID / PERIOD_NUM — the unique identifier and sequential number of the generated variable rent period.
• VAR_RENT_ID — foreign key to the parent variable rent agreement in PN_VAR_RENTS_ALL.
• START_DATE / END_DATE — the effective date range covered by the period.
• ACTUAL_VAR_RENT — sum of ACTUAL_INVOICED_AMOUNT from PN_VAR_RENT_INV_ALL for the period.
• FOR_VAR_RENT — forecast variable rent, computed as the sum of FOR_PER_RENT where ADJUST_NUM is zero, excluding adjustment records.
• DIFF_VAR_RENT — the arithmetic difference between ACTUAL_VAR_RENT and FOR_VAR_RENT, exposing variance at period level.
• ORG_ID — the operating unit identifier supporting multi-org security.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard EBS descriptive flexfield columns.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage includes form inquiry of generated periods for a variable rent agreement, reconciliation of forecast versus actual variable rent by period, and feeds into property management reporting or downstream financial extracts.

To retrieve all periods for a specific agreement:

• SELECT period_id, period_num, start_date, end_date, actual_var_rent, for_var_rent, diff_var_rent FROM apps.pn_var_periods_v WHERE var_rent_id = :p_var_rent_id ORDER BY period_num;

To identify periods carrying a material variance:

• SELECT var_rent_id, period_num, actual_var_rent, for_var_rent, diff_var_rent FROM apps.pn_var_periods_v WHERE org_id = :p_org_id AND diff_var_rent <> 0 ORDER BY ABS(diff_var_rent) DESC;

To summarize actual variable rent by agreement across a date range:

• SELECT var_rent_id, SUM(actual_var_rent) total_actual FROM apps.pn_var_periods_v WHERE start_date >= :p_from_date AND end_date <= :p_to_date GROUP BY var_rent_id;

Because the view aggregates invoiced amounts at query time, performance depends on indexing of PN_VAR_RENT_INV_ALL by PERIOD_ID and VAR_RENT_ID. Queries should always constrain on VAR_RENT_ID, ORG_ID, or the period date range to avoid full scans across all agreements.