Search Results pn_rec_expcl_dtl_all




Overview
Explore in AI Chat

Overview

The PN_REC_EXPCL_DTL_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 a detailed header table for managing expense class details. In the context of lease administration, an expense class categorizes the types of operating expenses (like utilities, maintenance, or taxes) associated with a leased property. This table stores the primary definitions and default settings for these expense class details, which are then used to allocate and process recurring expenses for lease agreements. Its multi-org structure, indicated by the "_ALL" suffix and the ORG_ID foreign key, allows it to store data for multiple operating units within a single installation.

Key Information Stored

The table's primary purpose is to define the relationship between an expense class and its associated expense lines and default area classifications. The primary key, EXPENSE_CLASS_DTL_ID, uniquely identifies each detail record. The most critical foreign keys define its core relationships: EXPENSE_CLASS_ID links to PN_REC_EXPCL_ALL to identify the parent expense class, and EXPENSE_LINE_ID links to PN_REC_EXP_LINE_ALL to specify the associated expense line item. The DEFAULT_AREA_CLASS_ID column links to PN_REC_ARCL_ALL, establishing a default area class (e.g., rentable, usable) for allocation calculations. The ORG_ID column ties the record to a specific business unit via HR_ALL_ORGANIZATION_UNITS, enforcing data security.

Common Use Cases and Queries

This table is central to configuring and reporting on lease expense recovery. A common use case is generating a setup report to audit all expense class details for a given lease or operating unit. For example, to list all expense class details for a specific expense class, one might query:

  • SELECT d.expense_class_dtl_id, e.expense_class_code, l.expense_line_code FROM pn_rec_expcl_dtl_all d, pn_rec_expcl_all e, pn_rec_exp_line_all l WHERE d.expense_class_id = e.expense_class_id AND d.expense_line_id = l.expense_line_id AND e.expense_class_code = 'UTILITIES';

Another critical scenario involves troubleshooting expense allocation issues by verifying the default area class assigned to an expense class detail. The table is also essential for any data migration or integration effort involving Property Manager's expense recovery engine, as it sits at the intersection of class, line, and area classification data.

Related Objects

PN_REC_EXPCL_DTL_ALL is a hub within a network of related Property Manager tables. Its primary parent tables are PN_REC_EXPCL_ALL (Expense Class) and PN_REC_EXP_LINE_ALL (Expense Line). It has a child table, PN_REC_EXPCL_DTLLN_ALL, which stores further line-level details, linked via the EXPENSE_CLASS_DTL_ID. The DEFAULT_AREA_CLASS_ID foreign key references PN_REC_ARCL_ALL (Area Class). For multi-org context, it references HR_ALL_ORGANIZATION_UNITS. Any custom reporting or interface involving lease expense details will likely need to join through this table to correctly associate expense classes with their corresponding lines and default allocation rules.