Results for “recovery_space_std_code”

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

Overview

PN_REC_EXPCL_INC_ALL is a Property Manager (PN) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores expense class inclusions associated with an expense class. In the Property Manager model, expense classes group recoverable operating costs so that they can be allocated, shared, and recovered from tenants under lease agreements. This table records the individual inclusion lines that determine how a given expense class participates in recovery — for example, the recovery type, the share percentage applied, and whether the fee is calculated before contractual deductions. It is therefore a configuration and rules table underpinning recovery processing rather than a transaction ledger.

Based on the heuristic Data Vault classification derived from the foreign key structure, this object is best modelled as a link. Its primary key identifies a relationship row, while its foreign keys connect the expense class inclusion to an operating unit and to an expense class type. The classification is a modeling suggestion only; in a native EBS context the table is simply a child of the expense class type definition.

Key Information Stored

The table carries 28 documented columns. The most significant are:

• EXPENSE_CLASS_INCLUSION_ID — the surrogate primary key, defined by constraint PN_REC_EXPCL_INC_PK. It is also exposed through the unique index PN_REC_EXPCL_INC_U1, making it the business-key candidate for row-level identification.
• EXPENSE_CLASS_TYPE_ID — foreign key to PN_REC_EXPCL_TYPE_ALL, tying the inclusion line to its parent expense class type.
• ORG_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, providing the operating unit (multi-org) context.
• RECOVERY_SPACE_STD_CODE and RECOVERY_TYPE_CODE — classify how recovery is measured and applied for the inclusion.
• CLS_INCL_SHARE_PCT — the percentage share applicable to the class inclusion during recovery calculations.
• CLS_INCL_FEE_BEFORE_CONTR — controls whether the fee is assessed before contractual deductions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — standard EBS audit and concurrency columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF (descriptive flexfield) columns reserved for customer-specific extension.

The surrogate key is distinct from any business identifier; the unique index on EXPENSE_CLASS_INCLUSION_ID merely enforces row uniqueness rather than defining a natural business key.

Common Use Cases and Queries

Typical scenarios include validating recovery setup, reporting inclusion shares by expense class, and auditing configuration changes before month-end recovery runs.

• Retrieve all inclusion lines for a specific expense class type:

  SELECT expense_class_inclusion_id, recovery_type_code, cls_incl_share_pct FROM pn_rec_expcl_inc_all WHERE expense_class_type_id = :p_expense_class_type_id;

• Restrict results to an operating unit in a multi-org environment:

  SELECT * FROM pn_rec_expcl_inc_all WHERE org_id = :p_org_id;

• Audit recently modified inclusion rules:

  SELECT expense_class_inclusion_id, last_update_date, last_updated_by FROM pn_rec_expcl_inc_all WHERE last_update_date >= :p_since_date;

• Verify that share percentages are populated correctly across all inclusions for recovery verification reporting.

Because the table is organization-scoped, any report or interface should filter on ORG_ID to respect security profile boundaries.

Related Objects

• PN_REC_EXPCL_TYPE_ALL — the parent expense class type definition, joined on EXPENSE_CLASS_TYPE_ID. This is the primary dependency for inclusion lines.
• HR_ALL_ORGANIZATION_UNITS — the operating unit master, joined on ORG_ID.
• PN_REC_EXPCL_INC_PK — the primary key constraint enforcing unique EXPENSE_CLASS_INCLUSION_ID values.
• PN_REC_EXPCL_INC_U1 — the unique index on EXPENSE_CLASS_INCLUSION_ID.
• Related Property Manager recovery setup tables and the recovery/expense-class concurrent programs that consume these inclusion rules during recovery processing.

Together, these objects form the expense class recovery configuration chain from operating unit through expense class type to inclusion line.