Results for “pn_rec_expcl_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PN_REC_EXPCL_ALL is a Property Manager (PN) transaction and setup table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores expense class setup information. Expense classes in Property Manager define how recoverable expenses are categorized, apportioned, and billed back to tenants across a portfolio of leased properties and areas. This table sits at the center of the expense recovery configuration model, holding the master expense class definition that governs portion percentages, fees, and currency, and that is subsequently referenced by agreement-level line items and expense class detail and type records.

From a Data Vault modeling perspective, the metadata characterisation of this object is hub-leaning. The table behaves as a durable master record keyed by a dedicated surrogate identifier, with limited descriptive attributes and a strong surrounding network of dependent child tables — a pattern consistent with a hub surrounded by satellites rather than a pure transactional link. This classification is a heuristic suggestion based on the foreign key topology, not a physical Data Vault implementation in the EBS schema.

Key Information Stored

The table contains 33 documented columns. The most significant are:

• EXPENSE_CLASS_ID — the surrogate primary key, enforced by PN_REC_EXPCL_PK, and also the single business-key candidate exposed through unique index PN_REC_EXPCL_U1.
• EXPENSE_CLASS_NUM and EXPENSE_CLASS_NAME — the user-facing identifier and description of the expense class.
• PROPERTY_ID — foreign key to PN_PROPERTIES_ALL, scoping the expense class to a specific property.
• AREA_CLASS_ID — foreign key to PN_REC_ARCL_ALL, linking the expense class to an area classification used for space allocation.
• PORTION_PCT — the percentage of the underlying expense that is recoverable or attributable to the class.
• CLASS_FEE_BEFORE_CONTR and CLASS_FEE_AFTER_CONTR — fee amounts applied before and after contractual adjustments.
• CURRENCY_CODE — the currency in which the class fees are denominated.
• LOCATION_ID — the operating location associated with the expense class.
• ORG_ID — the operating unit, foreign keyed to HR_ALL_ORGANIZATION_UNITS, enforcing multi-org partitioning.
• DESCRIPTION — free-text explanation of the class purpose.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns for extension.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing active expense classes by property, verifying portion and fee configuration before recovery billing, and validating multi-org partitioning. A representative query joining the property master is:

SELECT e.EXPENSE_CLASS_ID, e.EXPENSE_CLASS_NUM, e.EXPENSE_CLASS_NAME,
       e.PORTION_PCT, e.CLASS_FEE_AFTER_CONTR, e.CURRENCY_CODE
FROM   PN_REC_EXPCL_ALL e, PN_PROPERTIES_ALL p
WHERE  e.PROPERTY_ID = p.PROPERTY_ID
AND    e.ORG_ID = :p_org_id;

Analysts also join to PN_REC_EXPCL_DTL_ALL and PN_REC_EXPCL_TYPE_ALL to report the detail and type breakdowns of each class, and to PN_REC_AGR_LINEXP_ALL to trace which agreements consume a given expense class. Data migration scripts and interface programs commonly treat this table as the master setup source, extracting attributes through the DFF columns.

Related Objects

• PN_PROPERTIES_ALL — parent property master, joined on PROPERTY_ID; provides property-level context.
• PN_REC_ARCL_ALL — area classification master, joined on AREA_CLASS_ID.
• HR_ALL_ORGANIZATION_UNITS — operating unit master, joined on ORG_ID, for multi-org security and reporting.
• PN_REC_EXPCL_DTL_ALL — child detail records referencing EXPENSE_CLASS_ID.
• PN_REC_EXPCL_TYPE_ALL — child expense class type records referencing EXPENSE_CLASS_ID.
• PN_REC_AGR_LINEXP_ALL — agreement line expense records referencing EXPENSE_CLASS_ID.

These relationships make PN_REC_EXPCL_ALL the central hub for expense class configuration in Property Manager.