Search Results pn_rec_arcl_exc_pk

Overview

The PN_REC_ARCL_EXC_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Property Manager (PN) module. It is designed to store area class exclusion rules, which are critical for defining and managing the specific area classifications that are not applicable or are excluded from a property's recovery calculations. This table supports the multi-organization architecture of Oracle EBS, as indicated by the "_ALL" suffix and the presence of the ORG_ID column, allowing data to be partitioned by operating unit. Its primary function is to maintain the integrity and enforceability of complex lease and property management agreements by defining what is not recoverable under a given area classification.

Key Information Stored

The table's structure centers on linking an area class to its exclusions. The primary key, AREA_CLASS_EXCLUSION_ID, uniquely identifies each exclusion record. The most significant foreign key is AREA_CLASS_ID, which references the PN_REC_ARCL_ALL table, thereby tying each exclusion rule to a specific area class definition. The ORG_ID column, a foreign key to HR_ALL_ORGANIZATION_UNITS, enforces data security by segregating records according to the assigned operating unit. While the provided metadata does not list all columns, typical supporting columns would include standard Oracle EBS audit fields such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track record history.

Common Use Cases and Queries

This table is primarily accessed during the configuration of recovery area classes and the subsequent generation of recovery cost calculations. A common business scenario involves a property manager defining a standard office area class (e.g., "Rentable Office") but needing to exclude specific service areas, like janitorial closets or electrical rooms, from the recoverable square footage. This exclusion is stored in PN_REC_ARCL_EXC_ALL. A typical query would retrieve all exclusions for a given area class to validate or report on recovery rules:

• SELECT * FROM pn_rec_arcl_exc_all WHERE area_class_id = <class_id> AND org_id = <org_id>;

Data from this table is also integral to key Property Manager reports detailing the breakdown of recoverable versus non-recoverable areas for lease administration and billing purposes.

Related Objects

PN_REC_ARCL_EXC_ALL has defined relationships with several key EBS objects. Its primary parent table is PN_REC_ARCL_ALL, which stores the master definitions of recovery area classes. The integrity of the AREA_CLASS_ID foreign key ensures that every exclusion is linked to a valid class. For multi-org security, it references the HR_ALL_ORGANIZATION_UNITS table via the ORG_ID foreign key. The table is protected by the primary key constraint PN_REC_ARCL_EXC_PK. While not listed in the metadata, this table is likely referenced by various Property Manager application programming interfaces (APIs) and forms used to maintain area class rules, and it may serve as a source for key reporting views within the PN schema.