Search Results pn_rec_expcl_inc_all




Overview
Explore in AI Chat

Overview

The PN_REC_EXPCL_INC_ALL table is a core data repository within the Oracle E-Business Suite Property Manager (PN) module, specifically for release versions 12.1.1 and 12.2.2. As a multi-org enabled table (indicated by the '_ALL' suffix and the ORG_ID column), it stores master data that defines the relationship between expense classes and the specific expense items they include. Its primary role is to support the configuration and management of recoverable expenses in lease agreements, enabling precise control over which cost components are allocated to tenants. This table is essential for ensuring accurate expense recovery calculations and billing by maintaining the authorized list of expenses associated with a given expense class type.

Key Information Stored

The table's structure centers on linking an expense class type to its constituent items. The primary key, EXPENSE_CLASS_INCLUSION_ID, uniquely identifies each inclusion record. The most critical foreign key is EXPENSE_CLASS_TYPE_ID, which links directly to the PN_REC_EXPCL_TYPE_ALL table to define the parent expense class type (e.g., "Operating Expenses" or "Taxes"). While the provided metadata does not list all columns, the table's purpose implies it likely contains fields to specify the included expense item or account, potentially through a link to general ledger or inventory items. The ORG_ID column is mandatory, enforcing data partitioning by operating unit and aligning with Oracle EBS's multi-organization architecture.

Common Use Cases and Queries

This table is primarily accessed for setup, validation, and reporting related to lease expense recovery. A common operational use case is validating the items billable under a specific expense class before generating a recovery invoice. For reporting, analysts may query this table to audit or document the complete hierarchy of recoverable expenses. A typical SQL pattern involves joining to the parent expense class type table.

  • Listing all inclusions for a specific expense class type:
    SELECT inc.* FROM pn_rec_expcl_inc_all inc, pn_rec_expcl_type_all typ WHERE inc.expense_class_type_id = typ.expense_class_type_id AND typ.name = 'OPERATING_EXPENSES' AND inc.org_id = :p_org_id;
  • Identifying unused or orphaned expense class types by checking for a lack of inclusions:
    SELECT typ.name FROM pn_rec_expcl_type_all typ WHERE NOT EXISTS (SELECT 1 FROM pn_rec_expcl_inc_all inc WHERE inc.expense_class_type_id = typ.expense_class_type_id) AND typ.org_id = :p_org_id;

Related Objects

The PN_REC_EXPCL_INC_ALL table exists within a defined hierarchy and has documented foreign key relationships with other critical Property Manager tables.

  • PN_REC_EXPCL_TYPE_ALL: This is the primary parent table. The EXPENSE_CLASS_TYPE_ID column in PN_REC_EXPCL_INC_ALL references the PN_REC_EXPCL_TYPE_ALL table, defining the expense class to which the inclusion belongs.
  • HR_ALL_ORGANIZATION_UNITS: The ORG_ID column in PN_REC_EXPCL_INC_ALL references this table, enforcing valid operating unit assignments and enabling the multi-org security model.

This table is foundational for APIs and processes that generate recoverable expense schedules and invoices within the Property Manager module.