Search Results pn_opex_exp_grps_pk

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:

• EXPENSE_GRP_ID — the surrogate primary key, enforced by the PN_OPEX_EXP_GRPS_PK constraint and also carried by the unique index PN_OPEX_GRP_EXP_U1 (a documented business-key candidate).
• AGREEMENT_ID — the foreign reference to the parent operating expense agreement to which the group belongs.
• PRORAT_BASIS_DTL_ID — a foreign key linking to PN_OPEX_PRORAT_BASIS_DTLS_ALL, defining the proration basis detail used to allocate the group.
• EXPENSE_GRP_NAME and STD_GRP_NAME_CODE — the user-defined group name and the standardized group name code that maps the group to a seeded expense category.
• CONTRIBUTION_FLAG, CAP_FLAG, FEE_FLAG, TAX_FLAG, GROSS_UP_FLAG — behavioral flags controlling whether the group contributes to expense pools, is subject to caps, incurs fees or taxes, and is grossed up.
• MULTIPLE — a numeric factor applied to the group's base amounts.
• DESCRIPTION — free-text description of the group.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns for extensible client-defined attributes.
• ORG_ID — the operating unit identifier, supporting multi-org security.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

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.