Search Results pn_var_bkhd_defaults_n1

Overview

PN.PN_VAR_BKHD_DEFAULTS_ALL is a transactional configuration table in the Oracle Property Manager (PN) module of Oracle E-Business Suite, holding breakpoint header default definitions used by the variable rent engine. In the context of Oracle EBS 12.1.1 and 12.2.2, this table stores the header-level attributes that govern natural and artificial rent breakpoints applied to variable rent agreements. Each row represents a breakpoint setup record, capturing the effective dating, break type classification, natural break rate, and the artificial breakpoint treatment assigned to a given breakpoint line. Because it is an _ALL table, it is partitioned logically by ORG_ID and is expected to be filtered by operating unit or the appropriate Multi-Org security context in any query.

The table is described as "Breakpoint Header defaults" and is registered under FND Design Data as PN.PN_VAR_BKHD_DEFAULTS_ALL, with a status of VALID. Heuristic Data Vault classification mined from the foreign key structure places this object as standalone, meaning it does not participate in a strict hub/link/satellite dependency chain through its own key; a modeling suggestion would be to treat BKHD_DEFAULT_ID as a durable business key within a satellite-style attribute container, with the surrounding template and rent identifiers acting as descriptive references rather than enforced hierarchical links.

Key Information Stored

The table contains 39 documented columns. The most significant are:

• BKHD_DEFAULT_ID (NUMBER, mandatory) — Surrogate primary key, defined by the constraint PN_VAR_BKHD_DEFAULTS_PK and also enforced through the unique index PN_VAR_BKHD_DEFAULTS_U1. This is the column most commonly searched as "pn_var_bkhd_defaults_u1".
• BKHD_DETAIL_NUM — The number assigned to the breakpoint.
• LINE_DEFAULT_ID — Foreign key to PN_VAR_LINE_DEFAULTS_ALL, identifying the breakpoint line; also the leading column of the non-unique index PN_VAR_BKHD_DEFAULTS_N1.
• BKHD_START_DATE / BKHD_END_DATE — Effective date range of the breakpoint.
• BREAK_TYPE — Indicates whether the breakpoint is natural or artificial.
• NATURAL_BREAK_RATE — The rate applied for natural breakpoints.
• BREAKPOINT_TYPE — Type of artificial breakpoint and the treatment applied to the artificial breakpoint range.
• VAR_RENT_ID — Foreign key to PN_VAR_RENTS_ALL, tying the record to the owning variable rent agreement.
• BKPT_UPDATE_FLAG — Flag signalling whether records in PN_VAR_TRANSACTIONS_ALL must be updated for the breakpoint.
• LINE_TEMPLATE_ID, BKPT_HEAD_TEMPLATE_ID, AGREEMENT_TEMPLATE_ID — Template references for the line, header, and agreement.
• ORG_ID — Multi-Org operating unit identifier.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield structure and segment columns.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who audit columns.

Several columns are documented as not used, including BASE_RENT_TYPE, BASE_RENT, BREAKPOINT_LEVEL, LINE_TEMPLATE_ID usage notes, and PROCESSED_FLAG. These should be excluded from new reporting logic.

Common Use Cases and Queries

Typical use cases include reconciling breakpoint setup against variable rent agreements, auditing effective-dated breakpoint configurations, and generating reports of natural versus artificial breakpoint assignments.

A common lookup by the unique identifier:

• SELECT * FROM pn.pn_var_bkhd_defaults_all WHERE bkhd_default_id = :p_id;

Join to the line defaults and the variable rent agreement to report effective breakpoints per operating unit:

• SELECT h.bkhd_default_id, h.bkhd_detail_num, l.line_default_id, h.break_type, h.natural_break_rate, h.bkhd_start_date, h.bkhd_end_date FROM pn.pn_var_bkhd_defaults_all h, pn.pn_var_line_defaults_all l WHERE h.line_default_id = l.line_default_id AND h.org_id = :org_id;

Identify records flagged for transaction update via BKPT_UPDATE_FLAG to drive batch jobs against PN_VAR_TRANSACTIONS_ALL.

Related Objects

The following objects are the most significant dependents and references, based on the documented foreign key relationships:

• PN.PN_VAR_LINE_DEFAULTS_ALL — joined on LINE_DEFAULT_ID; parent of the breakpoint line.
• PN.PN_VAR_LINE_TEMPLATES_ALL — joined on LINE_TEMPLATE_ID.
• PN.PN_VAR_TEMPLATES_ALL — joined on AGREEMENT_TEMPLATE_ID; supplies agreement template defaults.
• PN.PN_VAR_RENTS_ALL — joined on VAR_RENT_ID; the owning variable rent agreement.
• PN.PN_VAR_BKDT_DEFAULTS_ALL — child table referencing this table via BKHD_DEFAULT_ID; holds breakpoint detail defaults.
• PN.PN_VAR_TRANSACTIONS_ALL — transactional table updated when BKPT_UPDATE_FLAG is set.