Results for “expense_class_id”

42 results




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

Overview

PN_REC_AGR_LINEXP_ALL is a transaction and setup table within the Oracle Property Manager (PN) module of Oracle E-Business Suite, documented as a "Recovery Expense set up table." It stores the expense class assignments that drive expense recovery processing for recovery agreements. In the Property Manager data model, recovery agreements are defined through a hierarchy of agreement headers, agreement lines, and line-level expense recovery rules. This table occupies the line-level detail tier, associating one or more expense classes with a specific recovery agreement line, together with effective dating that governs when each assignment is valid.

The table resides in the PN schema and is registered as VALID in the ETRM 12.2.2 repository. It is an _ALL table, meaning it is partitioned or filtered by operating unit through the ORG_ID column and is therefore subject to Multi-Org (MOAC) security in Release 12.

From a Data Vault modeling perspective, the documented foreign key structure classifies this object heuristically as a link table. It resolves the many-to-many relationship between recovery agreement lines and expense classes, and carries descriptive and effective-dating attributes (START_DATE, END_DATE) as link-level payload. Modelers should note that this classification is a suggestion derived from the FK topology rather than an Oracle-documented designation.

Key Information Stored

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

Common Use Cases and Queries

Typical uses include validating recovery setup before running expense recovery, reporting which expense classes are recovered under a given agreement, and auditing effective-dated changes. A representative join retrieves agreement line context for each expense assignment:

  • SELECT le.rec_agr_lineexp_id, ln.rec_agr_line_id, le.expense_class_id, le.start_date, le.end_date FROM pn_rec_agr_linexp_all le, pn_rec_agr_lines_all ln WHERE le.rec_agr_line_id = ln.rec_agr_line_id AND le.org_id = :p_org_id;
  • Filter by SYSDATE BETWEEN start_date AND end_date (or the equivalent NULL-safe pattern) to return only currently effective assignments.
  • Join EXPENSE_CLASS_ID to PN_REC_EXPCL_ALL to obtain expense class names for reporting.

Because ORG_ID is present, all queries executed through the EBS application layer should be scoped to the correct operating unit, or run with MOAC initialization to avoid cross-operating-unit leakage.

Related Objects

  • PN_REC_AGR_LINES_ALL — Parent recovery agreement line table; joined on REC_AGR_LINE_ID. Referenced twice in the documented FK set.
  • PN_REC_EXPCL_ALL — Expense class definitions; joined on EXPENSE_CLASS_ID. Referenced twice in the documented FK set.
  • HR_ALL_ORGANIZATION_UNITS — Operating unit / organization validation; joined on ORG_ID.
  • PN_REC_AGR_LINEXP_PK and PN_REC_AGR_LINEXP_U1 — The documented primary key constraint and unique index on REC_AGR_LINEXP_ID.
  • Property Manager recovery agreement entry forms and recovery processing concurrent programs, which read and write this setup data.