Search Results pn_rec_agr_lines_all




Overview
Explore in AI Chat

Overview

The PN_REC_AGR_LINES_ALL table is a core setup table within the Oracle E-Business Suite Property Manager (PN) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for defining individual recovery lines associated with a lease agreement. In the context of Property Manager's recovery functionality, this table stores the detailed rules and parameters for calculating a tenant's share of property operating expenses, such as common area maintenance (CAM), taxes, and insurance. Each record represents a distinct, configurable recovery line item that is linked to a parent recovery agreement. Its central role is to act as the primary source for all recovery line definitions, which are subsequently referenced throughout the billing and calculation engine.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the table's primary and foreign key structure reveals its critical data relationships. The primary key, REC_AGR_LINE_ID, uniquely identifies each recovery line. The foreign key REC_AGREEMENT_ID links the line to its parent master agreement in the PN_REC_AGREEMENTS_ALL table, establishing the core hierarchical relationship. The ORG_ID column implements multi-organization security by linking to HR_ALL_ORGANIZATION_UNITS. The table's description as a "setup table" implies it stores configuration attributes for each line, such as recovery type, calculation method, billing frequency, proration rules, and expense caps. The extensive list of child tables referencing REC_AGR_LINE_ID indicates this table holds the seed data from which all specific recovery calculations, billings, and area assignments are derived.

Common Use Cases and Queries

This table is fundamental for reporting on recovery agreement structures and troubleshooting billing issues. Common operational and analytical queries include listing all recovery lines for a specific agreement, identifying lines by recovery type, or validating setup before a billing run. A typical reporting query would join to the parent agreement and organization tables:

  • SELECT prala.rec_agr_line_id, praa.agreement_name, praa.agreement_num, hou.name org_name FROM pn_rec_agr_lines_all prala JOIN pn_rec_agreements_all praa ON prala.rec_agreement_id = praa.rec_agreement_id JOIN hr_all_organization_units hou ON prala.org_id = hou.organization_id WHERE praa.agreement_num = '<AGREEMENT_NUMBER>';

Technical consultants often query this table to understand the recovery line composition of an agreement or to trace data from a billing line (PN_REC_PERIOD_LINES_ALL) back to its source setup. It is also critical for data fixes or audits where the configuration of a recovery line needs to be examined or updated directly in the database.

Related Objects

The PN_REC_AGR_LINES_ALL table has a central position in the Property Manager data model, with documented relationships to numerous child setup and transaction tables. The key relationships, derived from the foreign key metadata, are as follows:

  • Parent Tables: References PN_REC_AGREEMENTS_ALL via REC_AGREEMENT_ID and HR_ALL_ORGANIZATION_UNITS via ORG_ID.
  • Child Tables (Setup & Assignment):
  • Child Tables (Transactions):
    • PN_REC_PERIOD_LINES_ALL (REC_AGR_LINE_ID): Stores the calculated recovery amounts per period.
    • PN_REC_PERIOD_BILL_ALL (REC_AGR_LINE_ID): Stores the billed recovery amounts.

This network of relationships confirms the table's role as the definitive source for recovery line definitions, which propagate to detailed assignments and ultimately to transactional billing records.