Search Results pn_var_bkpts_head_all




Overview
Explore in AI Chat

Overview

The PN_VAR_BKPTS_HEAD_ALL table is a core data object within the Property Manager (PN) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the master header table for storing breakpoint definitions, which are critical for calculating variable rent. Variable rent is a lease agreement component where the rental amount fluctuates based on a tenant's performance metrics, such as sales revenue. This table holds the overarching configuration and parameters for these breakpoints, which are then detailed in child tables. Its ALL suffix indicates it is a multi-organization access enabled (MOAC) table, storing data for all operating units and facilitating centralized management of property portfolios.

Key Information Stored

The table's primary identifier is the BKPT_HEADER_ID column, which is the primary key for the table. The most critical foreign key columns establish its relationships within the variable rent calculation hierarchy. The VAR_RENT_ID links the breakpoint header to a specific variable rent agreement (PN_VAR_RENTS_ALL). The LINE_ITEM_ID connects it to a particular line item within that agreement (PN_VAR_LINES_ALL), and the PERIOD_ID associates it with a specific accounting period for the calculation (PN_VAR_PERIODS_ALL). An additional self-referencing column, BKHD_DEFAULT_ID, allows for the inheritance or templating of breakpoint definitions from a default setup. While specific descriptive columns are not detailed in the provided metadata, typical data would include breakpoint names, calculation methods, statuses, and audit information like creation and last update dates.

Common Use Cases and Queries

This table is central to any process involving the setup, inquiry, or audit of variable rent calculations. A common reporting use case is to list all breakpoint headers for a specific variable rent agreement to understand the calculation structure. A typical query would join to PN_VAR_RENTS_ALL on VAR_RENT_ID and filter by a rent number or property identifier. For technical support, a frequent scenario involves tracing data issues by querying breakpoint headers for a specific lease line item and period. Developers customizing rent reports often query this table to fetch the breakpoint framework before joining to the detail table (PN_VAR_BKPTS_DET_ALL) to retrieve the actual threshold values and rates for financial calculations.

Related Objects

The PN_VAR_BKPTS_HEAD_ALL table is a pivotal node in the variable rent schema, with documented foreign key relationships to several key tables.

  • Parent Tables (Foreign Key References): It references PN_VAR_RENTS_ALL (on VAR_RENT_ID), PN_VAR_LINES_ALL (on LINE_ITEM_ID), and PN_VAR_PERIODS_ALL (on PERIOD_ID) to define its context within the lease and accounting timeline.
  • Self-Reference: It references itself via the BKHD_DEFAULT_ID column to enable default breakpoint templates.
  • Child Table (Referenced by): It is the primary parent table for PN_VAR_BKPTS_DET_ALL, which stores the specific breakpoint thresholds (e.g., sales tiers) and corresponding rates. The join is made on the BKPT_HEADER_ID column.
These relationships form the essential data model for configuring and storing multi-tiered variable rent calculations.