Search Results pn_rec_period_bill_pk

Overview

The PN_REC_PERIOD_BILL_ALL table is a core transactional data store within the Oracle E-Business Suite Property Manager (PN) module, specifically for the Reconciliation feature. Its primary role is to record the billed terms for a specific reconciliation period and agreement line. This table acts as the central repository for billed reconciliation amounts, serving as a critical link between the calculated reconciliation periods, the underlying lease agreement lines, and the subsequent payment terms that may be generated. As a multi-organization enabled table (indicated by the _ALL suffix and the ORG_ID foreign key), it supports the deployment of a single EBS instance across multiple business units or legal entities.

Key Information Stored

While the provided metadata does not list individual columns, the foreign key relationships and primary key define its critical structure. The table's unique identifier is the PERIOD_BILLREC_ID column, which constitutes its primary key (PN_REC_PERIOD_BILL_PK). The essential foreign key columns establish its core business relationships: REC_AGREEMENT_ID links to the master reconciliation agreement (PN_REC_AGREEMENTS_ALL), REC_AGR_LINE_ID links to the specific line item of that agreement (PN_REC_AGR_LINES_ALL), and REC_CALC_PERIOD_ID links to the calculated reconciliation period (PN_REC_CALC_PERIODS_ALL). The ORG_ID column ties the record to an operating unit in HR_ALL_ORGANIZATION_UNITS. The table's description, "Billed terms for a period and line table," implies it stores the financial results of the reconciliation calculation for billing, such as the billed amount, billing date, status, and associated tax or fee information for that specific line and period.

Common Use Cases and Queries

This table is fundamental for auditing reconciliation billing history and generating related financial reports. Common operational and reporting queries involve joining to its parent tables to analyze billed reconciliation amounts by lease, property, or period. A typical pattern is to trace the billed amount from the agreement line back to the original lease terms. For instance, a report to list all billed reconciliations for a specific agreement would join PN_REC_PERIOD_BILL_ALL to PN_REC_AGREEMENTS_ALL and PN_REC_AGR_LINES_ALL. Another critical use case is supporting the creation of payment terms; the foreign key relationship from PN_PAYMENT_TERMS_ALL indicates that records in this table are the source for generating payable or receivable items in the system. Sample SQL to analyze billed reconciliation data would follow this structure:

• SELECT prpb.*, pra.agreement_num, pral.line_number FROM pn_rec_period_bill_all prpb JOIN pn_rec_agreements_all pra ON prpb.rec_agreement_id = pra.rec_agreement_id JOIN pn_rec_agr_lines_all pral ON prpb.rec_agr_line_id = pral.rec_agr_line_id WHERE pra.agreement_num = '<AGREEMENT_NUM>' AND prpb.org_id = <ORG_ID>;

Related Objects

The PN_REC_PERIOD_BILL_ALL table is a central hub within the Reconciliation schema, with documented relationships to several key tables.

• Parent Tables (Referenced by Foreign Keys):
  • PN_REC_AGREEMENTS_ALL: Linked via REC_AGREEMENT_ID. The master reconciliation agreement.
  • PN_REC_AGR_LINES_ALL: Linked via REC_AGR_LINE_ID. The detailed line items of the reconciliation agreement.
  • PN_REC_CALC_PERIODS_ALL: Linked via REC_CALC_PERIOD_ID. The calculated period for which the reconciliation is billed.
  • HR_ALL_ORGANIZATION_UNITS: Linked via ORG_ID. Provides the operating unit context.
• Child Table (References this table via Foreign Key):
  • PN_PAYMENT_TERMS_ALL: Linked via PERIOD_BILLREC_ID. This relationship is crucial as it shows where the billed reconciliation terms are used to create formal payment obligations within the system.