Search Results pn_rec_expcl_type_all




Overview
Explore in AI Chat

Overview

The PN_REC_EXPCL_TYPE_ALL table is a core data structure within Oracle E-Business Suite Property Manager (PN). It functions as a master table for defining and storing the various types or categories that can be assigned to an expense class. An expense class in Property Manager is a classification used to group and track different kinds of property-related expenses, such as utilities, maintenance, or taxes. This table enables a more granular classification within those broader groups, providing a flexible, multi-organization-enabled framework for detailed expense tracking and recovery calculations. Its role is critical in the lease management and recovery accounting processes, ensuring expenses are correctly categorized for billing tenants or allocating costs.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal the essential data elements. The central column is EXPENSE_CLASS_TYPE_ID, which serves as the unique primary key identifier for each expense class type record. The table stores the association to a parent expense class via the EXPENSE_CLASS_ID foreign key, linking it to the PN_REC_EXPCL_ALL table. To support multi-organization architecture (Multi-Org), it includes an ORG_ID column, which foreign keys to HR_ALL_ORGANIZATION_UNITS, segregating data by operating unit. Typical columns in such a table would also include descriptive fields (e.g., NAME, DESCRIPTION), creation and last update dates (CREATION_DATE, LAST_UPDATE_DATE), and corresponding user ID columns for auditing.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of lease expense recovery. Common operational scenarios include defining recovery rules for specific expense types, generating detailed recovery reports by expense class and type, and validating data during invoice creation. A frequent reporting need is to list all active expense class types within an operating unit for a given expense class. A sample SQL pattern for such a query would be:

  • SELECT type.expense_class_type_id, type.name, ecl.name AS expense_class_name
  • FROM pn_rec_expcl_type_all type,
  • pn_rec_expcl_all ecl
  • WHERE type.expense_class_id = ecl.expense_class_id
  • AND type.org_id = 123 -- Specific operating unit
  • AND ecl.org_id = type.org_id
  • ORDER BY ecl.name, type.name;

This table is also central in joins for recovery calculation engines, where expense transactions are matched to their appropriate class type for proration.

Related Objects

The PN_REC_EXPCL_TYPE_ALL table sits at the center of several key relationships within the Property Manager schema, as documented by its foreign keys.

  • Referenced By (Parent Tables):
    • PN_REC_EXPCL_ALL: Via EXPENSE_CLASS_ID. This is the parent expense class definition table.
    • HR_ALL_ORGANIZATION_UNITS: Via ORG_ID. This links the data to the EBS operating unit structure.
  • Referenced In (Child Tables):
    • PN_REC_EXPCL_INC_ALL: Via EXPENSE_CLASS_TYPE_ID. This is a critical relationship, indicating that expense class types are directly used in defining recovery inclusion rules, which determine how expenses are allocated or billed to tenants.