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:
- REC_AGR_LINEXP_ID — The surrogate primary key, enforced by PN_REC_AGR_LINEXP_PK and also exposed through the unique index PN_REC_AGR_LINEXP_U1. This is the sole documented business-key candidate.
- REC_AGR_LINE_ID — Foreign key to PN_REC_AGR_LINES_ALL, identifying the recovery agreement line to which the expense assignment belongs. This is the principal business join column.
- EXPENSE_CLASS_ID — Foreign key to PN_REC_EXPCL_ALL, identifying the expense class being recovered on that line.
- START_DATE and END_DATE — Effective dating that defines the active window for the line/expense class assignment, enabling date-effective recovery calculations.
- ORG_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the operating unit that owns the record and enforcing multi-org data access.
- Who-columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard audit lineage for every row.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle EBS descriptive flexfield (DFF) columns, available for client-specific extensions.
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.
-
Recovery Expense set up table
-
Stores expense class details header information.
-
Recovery Expense set up table
-
Stores expense class details header information.
-
Stores expense class types associated with an expense class
-
Stores expense class types associated with an expense class
-
Stores expense class setup information
-
Stores expense class setup information
-
VIEW: PN.PN_REC_EXPCL_ALL# 12.2.2
-
VIEW: PN.PN_REC_EXPCL_ALL# 12.2.2
-
TABLE: PN.PN_REC_EXPCL_ALL 12.1.1
-
TABLE: PN.PN_REC_EXPCL_ALL 12.2.2
-
eTRM - PN Tables and Views 12.1.1
Interface table to contain batch lines information.
-
eTRM - PN Tables and Views 12.2.2
Interface table to contain batch lines information.
-
eTRM - PN Tables and Views 12.1.1
Interface table to contain batch lines information.
-
eTRM - PN Tables and Views 12.2.2
Interface table to contain batch lines information.