Search Results pn_rec_period_lines_all




Overview
Explore in AI Chat

Overview

The PN_REC_PERIOD_LINES_ALL table is a core transactional entity within Oracle E-Business Suite Property Manager (PN) module, versions 12.1.1 and 12.2.2. It serves as the detailed ledger for recovery calculations, storing the final computed recovery amounts for individual recovery agreement lines within specific calculation periods. This table is fundamental to the lease administration and recovery billing process, acting as the system of record for what a tenant is charged for operating expenses, common area maintenance (CAM), taxes, and other recoverable costs during a defined timeframe. Its multi-org structure, indicated by the "_ALL" suffix and the ORG_ID foreign key, supports implementations with multiple operating units.

Key Information Stored

While the full column list is not provided in the metadata, the documented foreign key relationships and primary key define its critical structure. The primary key, REC_PERIOD_LINES_ID, uniquely identifies each recovery line record. Each record links to a specific recovery agreement line (via REC_AGR_LINE_ID to PN_REC_AGR_LINES_ALL), defining the recoverable item, and to a specific calculation period (via REC_CALC_PERIOD_ID to PN_REC_CALC_PERIODS_ALL), defining the time frame. The CUST_ACCOUNT_ID links to HZ_CUST_ACCOUNTS, identifying the tenant/customer being billed. The ORG_ID links to HR_ALL_ORGANIZATION_UNITS, segregating data by operating unit. The table's description confirms it stores the calculated recovery amount for the period, implying columns for the calculated amount, potentially the billed amount, and status flags.

Common Use Cases and Queries

This table is central to generating tenant recovery statements and auditing recovery calculations. Common operational and reporting scenarios include generating a detailed recovery ledger for a specific tenant, auditing calculations for a recovery period, and reconciling billed amounts. A typical query would join to related master tables to produce a human-readable report.

Sample Query: Recovery Detail for a Customer and Period

  • SELECT prpla.rec_period_lines_id,
  • prpla.cust_account_id,
  • hca.account_number,
  • prala.rec_agr_line_id,
  • prcpa.period_name,
  • prpla.amount_calculated -- (example inferred column)
  • FROM pn_rec_period_lines_all prpla,
  • hz_cust_accounts hca,
  • pn_rec_agr_lines_all prala,
  • pn_rec_calc_periods_all prcpa
  • WHERE prpla.cust_account_id = hca.cust_account_id
  • AND prpla.rec_agr_line_id = prala.rec_agr_line_id
  • AND prpla.rec_calc_period_id = prcpa.rec_calc_period_id
  • AND hca.account_number = 'TENANT123'
  • AND prcpa.period_name = 'JAN-2024';

Related Objects

The table maintains defined foreign key relationships with several key master and transactional tables, as documented in the ETRM metadata.

  • PN_REC_AGR_LINES_ALL: Linked via REC_AGR_LINE_ID. This is the master definition of the recoverable item (e.g., CAM, Tax) within a recovery agreement.
  • PN_REC_CALC_PERIODS_ALL: Linked via REC_CALC_PERIOD_ID. This table defines the calculation period (start date, end date, status) for which the recovery amount is computed.
  • HZ_CUST_ACCOUNTS: Linked via CUST_ACCOUNT_ID. This TCA (Trading Community Architecture) table stores the customer/tenant master information.
  • HR_ALL_ORGANIZATION_UNITS: Linked via ORG_ID. This table defines the operating unit, enabling multi-org data partitioning.

The primary key PN_REC_PERIOD_LINES_PK (on REC_PERIOD_LINES_ID) is referenced by other tables or interfaces not listed in the provided excerpt, which would typically store further breakdowns or adjustments to the period line.