Search Results pn_rec_agr_linexp_all




Overview
Explore in AI Chat

Overview

The PN_REC_AGR_LINEXP_ALL table is a core data object within the Oracle E-Business Suite Property Manager (PN) module, specifically for versions 12.1.1 and 12.2.2. It functions as the master table for storing recovery expense setup details. Its primary role is to define and manage the specific expense classes that are recoverable under individual lines of a recovery agreement. This table establishes the critical link between a recovery agreement line item and the expense classifications (such as utilities, maintenance, or taxes) that are eligible for billing back to a tenant. By maintaining this relationship, it forms the foundation for accurate and automated recovery cost calculations and invoice generation within the lease management lifecycle.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships and primary key reveal the essential data elements. The primary key column, REC_AGR_LINEXP_ID, uniquely identifies each expense setup record. The most significant foreign keys define the table's core relationships: REC_AGR_LINE_ID links the expense setup to its parent recovery agreement line in the PN_REC_AGR_LINES_ALL table. The EXPENSE_CLASS_ID column links to the PN_REC_EXPCL_ALL (Expense Class) table, specifying the exact type of expense being recovered. The ORG_ID column implements the multi-org security model by tying the record to a specific operating unit via the HR_ALL_ORGANIZATION_UNITS table. Collectively, these columns store the configuration that dictates which costs are passed through to tenants.

Common Use Cases and Queries

This table is central to processes involving the setup, inquiry, and auditing of recoverable expenses. A primary use case is the generation of recovery invoices, where the system queries this table to determine which expense classes to include for a given agreement line. Implementation consultants and business analysts frequently query this table to validate setup or troubleshoot billing issues. A common reporting query involves joining to related tables to list all recoverable expense classes for an agreement.

SELECT prala.agreement_num,
       prala.line_num,
       prea.name expense_class,
       pralex.org_id
FROM   pn_rec_agr_linexp_all pralex,
       pn_rec_agr_lines_all  prala,
       pn_rec_expcl_all      prea
WHERE  pralex.rec_agr_line_id = prala.rec_agr_line_id
AND    pralex.expense_class_id = prea.expense_class_id
AND    prala.agreement_id = :p_agreement_id;

Related Objects

The PN_REC_AGR_LINEXP_ALL table is a child table with several documented foreign key dependencies, as per the provided ETRM metadata. Its relationships are fundamental to the Property Manager data model.

  • PN_REC_AGR_LINES_ALL: This is the primary parent table. The join is made on the column PN_REC_AGR_LINEXP_ALL.REC_AGR_LINE_ID referencing PN_REC_AGR_LINES_ALL. Each expense setup record must belong to a single recovery agreement line.
  • PN_REC_EXPCL_ALL: This table defines the valid expense classes. The join is made on the column PN_REC_AGR_LINEXP_ALL.EXPENSE_CLASS_ID referencing PN_REC_EXPCL_ALL. This relationship specifies the type of cost being recovered.
  • HR_ALL_ORGANIZATION_UNITS: This standard EBS table provides the operating unit context. The join is made on the column PN_REC_AGR_LINEXP_ALL.ORG_ID referencing HR_ALL_ORGANIZATION_UNITS, enforcing data partitioning by business entity.