Search Results pn_opex_exp_grps_all




Overview
Explore in AI Chat

Overview

The PN_OPEX_EXP_GRPS_ALL table is a core data object within the Oracle Property Manager (PN) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores expense group information for operating expense agreements, providing the organizational structure by which operating expenses are aggregated, allocated, and passed through to tenants under a lease or property agreement. Each expense group represents a logical category of recoverable expenses — for example, common area maintenance, insurance, real estate taxes, or utility charges — that a landlord tracks and reconciles against an operating expense agreement.

From a Data Vault modeling perspective, the metadata classifies this table heuristically as a standalone structure. In practice, it functions as a satellite surrounding the operating expense agreement header, since it carries descriptive and behavioral attributes (flags, names, proration references) that describe how expenses behave within the agreement, while the agreement itself acts as the parent hub.

Key Information Stored

The table contains 34 documented columns. The most significant of these are:

Common Use Cases and Queries

Typical usage includes recovering the active expense groups for an agreement, validating flag configuration, and joining to proration and agreement tables for reconciliation reporting. A representative query lists expense groups for a given agreement:

  • SELECT e.EXPENSE_GRP_ID, e.EXPENSE_GRP_NAME, e.STD_GRP_NAME_CODE, e.CONTRIBUTION_FLAG, e.CAP_FLAG, e.GROSS_UP_FLAG FROM PN_OPEX_EXP_GRPS_ALL e WHERE e.AGREEMENT_ID = :p_agreement_id AND e.ORG_ID = :p_org_id;
  • Joining to the proration basis detail: SELECT e.EXPENSE_GRP_NAME, p.* FROM PN_OPEX_EXP_GRPS_ALL e, PN_OPEX_PRORAT_BASIS_DTLS_ALL p WHERE e.PRORAT_BASIS_DTL_ID = p.PRORAT_BASIS_DTL_ID;
  • Identifying gross-up or cap-affected groups: SELECT EXPENSE_GRP_ID, EXPENSE_GRP_NAME FROM PN_OPEX_EXP_GRPS_ALL WHERE GROSS_UP_FLAG = 'Y' OR CAP_FLAG = 'Y';

These patterns support operating expense audit reports, tenant billing analysis, and configuration validation before running expense reconciliation processes.

Related Objects

The most significant related objects, derived from the documented foreign key and primary key relationships, include:

  • PN_OPEX_PRORAT_BASIS_DTLS_ALL — referenced through PRORAT_BASIS_DTL_ID; supplies the proration basis details for allocation.
  • Operating expense agreement tables (PN_OPEX_AGREEMENTS / agreement headers) — the parent object referenced through AGREEMENT_ID.
  • PN_OPEX_EXP_GRPS_PK — the primary key constraint enforcing uniqueness of EXPENSE_GRP_ID.
  • PN_OPEX_GRP_EXP_U1 — the unique index on EXPENSE_GRP_ID, serving as the documented business-key candidate.
  • Property Manager expense recovery and billing entities — dependent processes that consume expense group configuration when calculating tenant recoverable expenses.

Together these objects form the configuration backbone for operating expense pass-through processing in Oracle Property Manager.