Search Results pn_var_line_defaults_all

Overview

The PN_VAR_LINE_DEFAULTS_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Property Manager (PN) module. Its primary function is to store default configuration templates for variable rent lines, organized by operating unit (organization). This table enables the standardization and efficient setup of variable rent calculations across multiple leases, ensuring consistency in how variable rent components, such as percentage rent or expense recoveries, are defined and processed. By acting as a master source for line setups, it reduces manual data entry and minimizes errors during the lease administration lifecycle in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's central purpose is to define reusable line templates. The most critical column is the LINE_DEFAULT_ID, which serves as the unique primary key identifier for each default line setup record. While the provided metadata does not list all columns, standard implementation suggests the table also includes an ORG_ID column to partition data by operating unit, aligning with the "_ALL" naming convention. Other typical columns would store default values for the line type, calculation frequency, associated natural account, and other attributes that define a variable rent line. These defaults are then referenced when creating specific variable rent lines for individual leases.

Common Use Cases and Queries

A primary use case is the generation of reports listing all available variable rent line defaults for an organization, which aids in audit and setup verification. Administrators often query this table to identify which default template was used for a specific lease line. A common SQL pattern involves joining to the related lines table using the LINE_DEFAULT_ID.

• Find all defaults for an organization: SELECT line_default_id, <other_attributes> FROM pn_var_line_defaults_all WHERE org_id = :org_id;
• Find specific variable rent lines using a particular default: SELECT v.* FROM pn_var_lines_all v, pn_var_line_defaults_all d WHERE v.line_default_id = d.line_default_id AND d.line_default_id = :specific_id;

Related Objects

The table has a direct and documented foreign key relationship with the PN_VAR_LINES_ALL table, which stores the actual variable rent lines for specific leases. This relationship is fundamental to the data model.

• PN_VAR_LINES_ALL: This table references PN_VAR_LINE_DEFAULTS_ALL via its LINE_DEFAULT_ID column. This link allows individual variable rent lines on a lease to inherit their core setup parameters from a centralized, organization-level default template.

The primary key constraint PN_VAR_LINE_DEFAULTS_PK on LINE_DEFAULT_ID ensures the integrity of this relationship, guaranteeing that each default template is uniquely identifiable when referenced by lease-specific lines.