Search Results rec_agr_linconst_id

Overview

The PN_REC_AGR_LINCONST_ALL table is a core data object within the Oracle E-Business Suite (EBS) Property Manager (PN) module, specifically for versions 12.1.1 and 12.2.2. As documented in the ETRM, it serves as the "Recovery Constraint set up table." Its primary role is to store the detailed constraint rules and conditions associated with individual recovery agreement lines. These constraints define the specific parameters and limits for how expenses are recovered from tenants, such as caps on recoverable amounts, escalation rules based on indices, and other contractual limitations. The table supports multi-organization architecture through its `ORG_ID` column, allowing constraint data to be partitioned by operating unit.

Key Information Stored

The table's structure is designed to link constraints to their parent agreement lines and define their operational boundaries. Key columns, as indicated by the primary and foreign key metadata, include:

• REC_AGR_LINCONST_ID: The primary key identifier for each unique constraint record.
• REC_AGR_LINE_ID: A critical foreign key linking the constraint to its parent recovery agreement line in the PN_REC_AGR_LINES_ALL table.
• ORG_ID: The operating unit identifier, linking to HR_ALL_ORGANIZATION_UNITS, which enables multi-org data segregation.
• CPI_INDEX: A foreign key to PN_INDEX_HISTORY_HEADERS, used when a constraint involves escalation or calculation tied to a Consumer Price Index or similar published index.

While the full column list is not provided, typical constraint data would also include fields for constraint type, applicable period, monetary limits (e.g., maximum recovery amount, stop amount), and calculation formulas.

Common Use Cases and Queries

This table is central to generating accurate tenant recovery statements and performing lease abstraction analysis. A common use case is auditing the recovery constraints applied to a specific lease or agreement line to validate billing calculations. For reporting, one might join this table to the agreement lines and headers to list all constraints for an agreement. A typical query pattern would be:

SELECT h.agreement_num, l.line_number, c.constraint_type, c.max_amount
FROM pn_rec_agr_linconst_all c,
pn_rec_agr_lines_all l,
pn_rec_agr_headers_all h
WHERE c.rec_agr_line_id = l.rec_agr_line_id
AND l.rec_agr_header_id = h.rec_agr_header_id
AND h.agreement_num = '<AGREEMENT_NUMBER>';

Another critical scenario is during the period-end reconciliation process, where the system references these constraints to compute the final recoverable amounts for each tenant, ensuring compliance with lease terms.

Related Objects

As defined by its foreign keys, PN_REC_AGR_LINCONST_ALL has integral relationships with several other EBS tables. Its primary dependency is on PN_REC_AGR_LINES_ALL, the table for recovery agreement lines. It also references PN_INDEX_HISTORY_HEADERS for index-based calculations and HR_ALL_ORGANIZATION_UNITS for organizational context. The table is protected by the primary key constraint PN_REC_AGR_LINCONST_PK. For transactional operations and data integrity, it is typically accessed via Property Manager's public APIs or through its associated user interface forms, rather than via direct DML.