Results for “gross_up_flag”

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

Overview

The PN_OPEX_RECON_EXP_GRP_ALL table is a core data object within the Oracle Property Manager (PN) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores expense group information associated with operating expense (opex) reconciliations. In Property Manager, operating expense reconciliations represent the periodic process of trueing up a tenant's share of building operating costs against estimated payments made throughout the lease year. This table captures the grouping construct that determines how reconciled expenses are aggregated, prorated, and passed through to tenants.

From a data modeling perspective, the heuristic Data Vault classification for this table is standalone, meaning it is not clearly a hub, link, or satellite when mined purely from its foreign key structure. As a modeling suggestion, it functions much like a link or a dependent child entity that binds a reconciliation header to expense group definitions and proration detail records. The table is owned by the PN schema and is flagged VALID in the data dictionary.

Key Information Stored

The table contains 40 documented columns. Its surrogate primary key is RECON_EXP_GRP_ID, enforced through the PN_OPEX_RECON_EXP_GRP_PK constraint. A unique index, PN_OPEX_RECON_EXP_GRP_U1, also exists on RECON_EXP_GRP_ID, making it the documented business-key candidate. The most significant columns include:

• RECON_EXP_GRP_ID — Surrogate primary key uniquely identifying each reconciliation expense group row.
• RECON_ID — Foreign key to PN_OPEX_RECON_ALL, linking the group to its parent reconciliation header.
• EXP_GRP_ID — Identifier of the expense group being reconciled.
• EXPENSE_GRP_NAME — Descriptive name of the expense group.
• PRORAT_BASIS_NAME and PRORAT_BASIS_DTL_ID — The proration basis used, with a foreign key to PN_OPEX_PRORAT_BASIS_DTLS_ALL.
• AMOUNT_ST / AMOUNT_OVR — Standard and override amounts applied to the group.
• MULTIPLE_ST / MULTIPLE_EXP — Standard and expected multipliers applied during proration.
• RECOVERABLE_ST / RECOVERABLE_OVR — Standard and override recoverable amounts.
• CAP_FLAG, FEE_FLAG, TAX_FLAG, GROSS_UP_FLAG, CONTRIBUTION_FLAG — Behavior indicators controlling capitalization, fees, taxes, gross-up treatment, and contribution handling.
• ORG_ID — Multi-org operating unit identifier enabling data segregation across business units.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — Descriptive flexfield (DFF) columns supporting extensible, client-specific data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.

The COLUMN named RECON_EXP_GRP_ID doubles as both the primary key and the documented unique business key. The presence of ST (standard) and OVR (override) column pairs reflects the configuration-versus-override design pattern common throughout Property Manager.

Common Use Cases and Queries

Typical use cases involve generating reconciliation reports, validating proration setup, and auditing expense group configuration for a given reconciliation. A representative query retrieves all expense groups for a reconciliation:

• SELECT RECON_EXP_GRP_ID, EXPENSE_GRP_NAME, PRORAT_BASIS_NAME, AMOUNT_ST, RECOVERABLE_ST FROM PN_OPEX_RECON_EXP_GRP_ALL WHERE RECON_ID = :p_recon_id;
• Joining to the parent reconciliation header to report reconciliation status: SELECT g.EXPENSE_GRP_NAME, r.STATUS FROM PN_OPEX_RECON_EXP_GRP_ALL g, PN_OPEX_RECON_ALL r WHERE g.RECON_ID = r.RECON_ID;
• Auditing proration basis assignments by joining to PN_OPEX_PRORAT_BASIS_DTLS_ALL on PRORAT_BASIS_DTL_ID.
• Flexfield reporting using ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.
• Multi-org reporting filtered by ORG_ID for operating unit-specific analysis.

Related Objects

The table participates in the following documented relationships:

• PN_OPEX_RECON_ALL — Parent reconciliation header, joined via RECON_ID.
• PN_OPEX_PRORAT_BASIS_DTLS_ALL — Proration basis details, joined via PRORAT_BASIS_DTL_ID.
• PN_OPEX_RECON_EXP_GRP_PK — Primary key constraint defining RECON_EXP_GRP_ID.
• PN_OPEX_RECON_EXP_GRP_U1 — Unique index on RECON_EXP_GRP_ID.
• Expense group master data (referenced through EXP_GRP_ID) and DFF definition tables that render the ATTRIBUTE columns.

Together these objects support the end-to-end operating expense reconciliation process within Oracle Property Manager.