Results for “variance_exp_code”

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

Overview

PN_ACT_RENT_DETAILS_V is an APPS-owned database view in the Oracle E-Business Suite Property Manager (PN) module, the component of Oracle ETRM (Enterprise Territory and Property Management) that governs lease and property rent calculations. The view is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is defined in the APPS schema. Its documented purpose is to present actual variable rent details broken down by line item and group date, giving users a consolidated, calculation-ready picture of how variable rent amounts are derived for a given transaction line.

Variable rent in Property Manager applies when rent is calculated against metered volumes (for example, sales-based or throughput-based rent) that accumulate across proration periods and are evaluated against volume breakpoints. PN_ACT_RENT_DETAILS_V exposes the prorated breakpoint boundaries and the resulting applied volume and rent amount for each group date, tagged with the literal var_rent_type value 'ACTUAL'. Because it assembles data from multiple PN base objects and invokes the PN_VARIABLE_AMOUNT_PKG API, it functions as a reporting and integration surface: external reports, custom concurrent programs, and downstream interfaces can query it instead of reconstructing the proration and breakpoint logic themselves.

Underlying Base Objects

The view is defined over the following documented objects:

• PN_VAR_RENTS — the master variable rent definition, supplying cumulative volume (vr.cumulative_vol) and org_id.
• PN_VAR_PERIODS_ALL — the rent period definitions, supplying period start and end dates used in proration.
• PN_VAR_GRP_DATES_ALL — group date records supplying group_start_date, group_end_date, group_date, invoice_date, proration_factor, and the expense code columns (actual, forecasted, variance).
• PN_VAR_RENT_SUMM_ALL — the volume summary table supplying line_item_id, total actual volume (tot_act_vol), and total deductions (tot_ded).
• PN_VAR_BKPTS_DET_ALL and PN_VAR_BKPTS_HEAD_ALL — accessed through an inline breakpoint subquery, supplying period and group breakpoint volume start/end values and the breakpoint rate.
• PN_VARIABLE_AMOUNT_PKG — the PL/SQL package supplying the get_prorated_bkpt function that computes prorated breakpoint positions.

The joins tie each variable rent to its period, its group dates, and the summarized volumes for a line item, with breakpoint detail applied during the calculation.

Key Columns

• group_date, invoice_date — the group date and associated invoice date for the calculation.
• line_item_id — the transaction line item the variable rent relates to, the primary reporting key.
• tot_vol — total actual volume, computed as tot_act_vol minus NVL(tot_ded,0).
• bkpt_vol_start, bkpt_vol_end — prorated starting and ending volume positions for the breakpoint tier.
• vol_appl — volume applicable within the tier, the difference between bkpt_vol_end and bkpt_vol_start.
• bkpt_rate — the rate applied to the applicable volume.
• var_rent — calculated variable rent, vol_appl multiplied by bkpt_rate.
• actual_exp_code, forecasted_exp_code, variance_exp_code — expense codes used for accounting distributions.
• var_rent_type — literal 'ACTUAL', distinguishing this view's rows from forecast-based equivalents.
• org_id — the operating unit, supporting multi-org security.

Common Use Cases and Queries

Typical applications include reconciling actual variable rent by line item, auditing prorated breakpoint tiers, and feeding general ledger or intercompany processes. A representative query:

• SELECT line_item_id, group_date, tot_vol, bkpt_vol_start, bkpt_vol_end, vol_appl, bkpt_rate, var_rent FROM pn_act_rent_details_v WHERE group_date BETWEEN :p_start AND :p_end ORDER BY line_item_id, group_date;
• SELECT line_item_id, SUM(var_rent) actual_rent FROM pn_act_rent_details_v WHERE org_id = :p_org GROUP BY line_item_id;
• SELECT group_date, invoice_date, actual_exp_code, forecasted_exp_code, variance_exp_code, var_rent FROM pn_act_rent_details_v WHERE line_item_id = :p_line_item_id;

Because the view calls PN_VARIABLE_AMOUNT_PKG per row, performance-sensitive reports should filter by line_item_id, group_date, or org_id before aggregation.