Search Results pn_rec_expcl_all




Overview
Explore in AI Chat

Overview

The PN_REC_EXPCL_ALL table is a core data structure within the Property Manager (PN) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for expense class setup information. An expense class is a critical configuration element used to categorize and allocate recurring property expenses, such as utilities, maintenance, or taxes, across leased properties and their specific areas. This table enables the systematic definition and management of these expense categories, forming the foundation for accurate expense recovery calculations and billing processes in a multi-organization, multi-property environment, as indicated by its "_ALL" suffix.

Key Information Stored

The table's primary key is the EXPENSE_CLASS_ID, a unique system-generated identifier for each expense class record. Its structure enforces critical business relationships through foreign key constraints. The PROPERTY_ID column links each expense class to a specific property defined in PN_PROPERTIES_ALL, while the AREA_CLASS_ID references a defined area classification (e.g., rentable, usable) in PN_REC_ARCL_ALL. The ORG_ID column ties the setup to a specific operating unit via HR_ALL_ORGANIZATION_UNITS, enforcing data security by organization. Other essential columns typically include attributes for the expense class name, description, active status, and standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

This table is central to setup, reporting, and transactional integrity. A common use case is validating or reporting the expense classes available for a specific property and operating unit. For instance, a query to list all active expense classes for a property would join PN_REC_EXPCL_ALL to PN_PROPERTIES_ALL. Another critical scenario involves troubleshooting data issues in recovery agreements or billing lines by tracing the expense class back to its master definition. Developers often reference this table when customizing expense allocation logic or building interfaces. A typical SQL pattern retrieves the expense class setup for a lease area:

  • SELECT expcl.expense_class_id, expcl.name, prop.property_name, arcl.area_class_code FROM pn_rec_expcl_all expcl, pn_properties_all prop, pn_rec_arcl_all arcl WHERE expcl.property_id = prop.property_id AND expcl.area_class_id = arcl.area_class_id AND expcl.org_id = :p_org_id;

Related Objects

As documented in the foreign key relationships, PN_REC_EXPCL_ALL is a parent table to several key transactional and setup tables. PN_REC_EXPCL_DTL_ALL holds detailed parameters for each expense class. PN_REC_EXPCL_TYPE_ALL associates expense classes with specific expense types. Crucially, PN_REC_AGR_LINEXP_ALL references this table to assign expense classes to individual lines within a recovery agreement. The table itself is a child of PN_PROPERTIES_ALL (for the property) and PN_REC_ARCL_ALL (for the area class). This network of relationships underscores its role as a central hub in the Property Manager's recurring expense management schema.