Search Results pn_var_deductions_all




Overview
Explore in AI Chat

Overview

The PN_VAR_DEDUCTIONS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Property Manager (PN) module. It serves a critical function in the calculation of variable rent, which is a common component of commercial lease agreements where rent amounts fluctuate based on specific performance metrics, such as a percentage of a tenant's sales. The table's primary role is to store detailed deduction records that are applied to individual line items during the variable rent computation process. These deductions reduce the calculated variable rent amount, allowing for the accurate modeling of complex lease terms that include allowances, caps, or exclusions. As an "ALL" table, it is designed to support the multi-organization architecture (Multi-Org) of Oracle EBS, meaning it stores data partitioned by the operating unit (ORG_ID), which is a mandatory column.

Key Information Stored

The table stores transactional data for each deduction defined against a variable rent line item. While the full column list is not provided in the excerpt, the documented foreign keys and primary key reveal its essential structure. The primary key is DEDUCTION_ID, a unique identifier for each deduction record. The table links to other key variable rent entities via foreign key columns: PERIOD_ID references a specific variable rent period in PN_VAR_PERIODS_ALL, LINE_ITEM_ID points to the associated rent line in PN_VAR_LINES_ALL, and GRP_DATE_ID connects to a grouping date in PN_VAR_GRP_DATES_ALL. A critical financial link is the GL_ACCOUNT_ID, which references GL_CODE_COMBINATIONS to determine the General Ledger account for posting the deduction amount. Other typical columns would include the deduction AMOUNT or PERCENTAGE, a DESCRIPTION, and the standard EBS WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

The primary use case is the generation and audit of variable rent invoices. During the variable rent calculation engine run, the system queries this table to apply all configured deductions for a lease's line items within a specific period. Common reporting needs include analyzing total deductions by lease, period, or account. A sample query to list deductions for a specific variable rent period would be:

  • SELECT d.deduction_id, d.amount, l.line_item_name, g.segment1 gl_account
  • FROM pn_var_deductions_all d,
  • pn_var_lines_all l,
  • gl_code_combinations g
  • WHERE d.period_id = :p_period_id
  • AND d.line_item_id = l.line_item_id
  • AND d.gl_account_id = g.code_combination_id
  • AND d.org_id = :p_org_id;

Technical consultants may also query this table to troubleshoot calculation discrepancies or to validate data migration during implementations or upgrades.

Related Objects

PN_VAR_DEDUCTIONS_ALL is centrally connected to several other Property Manager tables, as documented by its foreign key constraints. The key relationships are:

  • PN_VAR_PERIODS_ALL: Joined via PERIOD_ID. This defines the time period for which the variable rent and its deductions are calculated.
  • PN_VAR_LINES_ALL: Joined via LINE_ITEM_ID. This identifies the specific variable rent line (e.g., "Percentage Rent" or "CAM Charges") to which the deduction applies.
  • PN_VAR_GRP_DATES_ALL: Joined via GRP_DATE_ID. This links to date groupings used for organizing calculation data.
  • GL_CODE_COMBINATIONS: Joined via GL_ACCOUNT_ID. This critical link ties the financial impact of the deduction to the General Ledger for proper accounting.

These relationships form the backbone of the variable rent calculation data model, ensuring referential integrity between deductions, their associated rent lines, calculation periods, and final financial postings.

  • Table: PN_VAR_DEDUCTIONS_ALL 12.2.2

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_DEDUCTIONS_ALL,  object_name:PN_VAR_DEDUCTIONS_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores deductions to be applied to each line item for calculation of variable rent. ,  implementation_dba_data: PN.PN_VAR_DEDUCTIONS_ALL , 

  • Table: PN_VAR_DEDUCTIONS_ALL 12.1.1

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_DEDUCTIONS_ALL,  object_name:PN_VAR_DEDUCTIONS_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores deductions to be applied to each line item for calculation of variable rent. ,  implementation_dba_data: PN.PN_VAR_DEDUCTIONS_ALL , 

  • Table: PN_VAR_LINES_ALL 12.1.1

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_LINES_ALL,  object_name:PN_VAR_LINES_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores information related to line items associated within each period for a variable rent. ,  implementation_dba_data: PN.PN_VAR_LINES_ALL , 

  • Table: PN_VAR_LINES_ALL 12.2.2

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_LINES_ALL,  object_name:PN_VAR_LINES_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores information related to line items associated within each period for a variable rent. ,  implementation_dba_data: PN.PN_VAR_LINES_ALL , 

  • Table: PN_VAR_GRP_DATES_ALL 12.1.1

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_GRP_DATES_ALL,  object_name:PN_VAR_GRP_DATES_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores critical dates related to the variable rent agreement generated by the periods generation program. ,  implementation_dba_data: PN.PN_VAR_GRP_DATES_ALL , 

  • Table: PN_VAR_GRP_DATES_ALL 12.2.2

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_GRP_DATES_ALL,  object_name:PN_VAR_GRP_DATES_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores critical dates related to the variable rent agreement generated by the periods generation program. ,  implementation_dba_data: PN.PN_VAR_GRP_DATES_ALL , 

  • Table: PN_VAR_PERIODS_ALL 12.1.1

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_PERIODS_ALL,  object_name:PN_VAR_PERIODS_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores information about periods generated by the periods generation program for the duration of variable rent. ,  implementation_dba_data: PN.PN_VAR_PERIODS_ALL , 

  • Table: PN_VAR_PERIODS_ALL 12.2.2

    owner:PN,  object_type:TABLE,  fnd_design_data:PN.PN_VAR_PERIODS_ALL,  object_name:PN_VAR_PERIODS_ALL,  status:VALID,  product: PN - Property Manager ,  description: Stores information about periods generated by the periods generation program for the duration of variable rent. ,  implementation_dba_data: PN.PN_VAR_PERIODS_ALL ,