Results for “pn_var_line_defaults_all”

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

Overview

PN_VAR_LINE_DEFAULTS_ALL is a Property Manager (PN) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores default line setup information for variable rent, organized by operating unit. Variable rent arrangements allow property managers to calculate rent as a percentage of a tenant's sales rather than (or in addition to) a fixed base rent. This table holds the default attributes that govern how variable rent lines are constructed before they are actually generated and persisted in the transaction-level variable rent line tables. The _ALL suffix indicates the table is partitioned or filtered by ORG_ID, meaning rows are segregated by organization.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying this object as a standalone entity. Although it carries a surrogate primary key (LINE_DEFAULT_ID) and several foreign keys to parent reference tables, the heuristic yields a standalone classification rather than a hub, link, or satellite. This reflects its role as a configuration/defaults table rather than a core transactional or hierarchical entity. The ETRM metadata lists 32 columns, with the primary key supported by unique index PN_VAR_LINE_DEFAULTS_U1 on LINE_DEFAULT_ID.

Key Information Stored

The most significant columns in this table are:

• LINE_DEFAULT_ID — the surrogate primary key (PN_VAR_LINE_DEFAULTS_PK) uniquely identifying each default line setup record; also the sole business-key candidate via unique index PN_VAR_LINE_DEFAULTS_U1.
• ORG_ID — the operating unit that owns the default record, enabling multi-organization segregation.
• LINE_NUM — sequencing of the default line within its parent grouping.
• VAR_RENT_ID — foreign key to PN_VAR_RENTS_ALL, linking the default to the parent variable rent definition.
• LINE_TEMPLATE_ID — foreign key to PN_VAR_LINE_TEMPLATES_ALL, referencing the line template used as the basis for the line.
• AGREEMENT_TEMPLATE_ID — foreign key to PN_VAR_TEMPLATES_ALL, referencing the agreement template governing the default setup.
• SALES_TYPE_CODE — categorization of the sales type for which the variable rent line applies.
• ITEM_CATEGORY_CODE — category of items tied to the variable rent calculation.
• LINE_START_DATE and LINE_END_DATE — effective dating window for the default line.
• PROCESSED_FLAG — indicates whether the default line has been processed into an actual variable rent line.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard flexfield (descriptive flexfield) columns for extensibility.

Common Use Cases and Queries

Typical scenarios include retrieving the default line templates configured for a specific variable rent agreement, auditing which defaults have not yet been processed, and reporting on template usage across operating units. A representative query joins defaults to their parent variable rent and line templates:

SELECT d.LINE_DEFAULT_ID, d.LINE_NUM, d.SALES_TYPE_CODE,
       d.ITEM_CATEGORY_CODE, d.LINE_START_DATE, d.LINE_END_DATE,
       d.PROCESSED_FLAG, r.NAME
FROM   PN_VAR_LINE_DEFAULTS_ALL d,
       PN_VAR_RENTS_ALL r
WHERE  d.VAR_RENT_ID = r.VAR_RENT_ID
AND    d.ORG_ID = :org_id;

Reporters frequently filter on PROCESSED_FLAG to identify defaults awaiting generation, and on the effective date columns for point-in-time analysis. Because the table is organization-partitioned, all queries should include ORG_ID predicates for performance and correctness.

Related Objects

The following objects are most significant to this table:

• PN_VAR_LINES_ALL — references PN_VAR_LINE_DEFAULTS_ALL via LINE_DEFAULT_ID; stores the actual generated variable rent lines derived from these defaults.
• PN_VAR_RENTS_ALL — parent table joined via VAR_RENT_ID.
• PN_VAR_LINE_TEMPLATES_ALL — referenced via LINE_TEMPLATE_ID.
• PN_VAR_TEMPLATES_ALL — agreement template parent referenced via AGREEMENT_TEMPLATE_ID.
• PN_VAR_BKHD_DEFAULTS_ALL — references this table via LINE_DEFAULT_ID, holding related background defaults.