Results for “area_type”
11 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PN_REC_AGR_LINAREA_ALL is the Recovery Area setup table within the Oracle Property Manager (PN) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the allocation of recovery areas to recovery agreements, acting as the bridge between agreement lines and area classes. Each row defines the percentage of a recoverable area that a given agreement line is entitled to recover, along with the dates over which that allocation is effective. This table is foundational to lease recovery processing, where tenants and landlords apportion shared operating costs across leased spaces.
From a data warehousing perspective, the heuristic Data Vault classification for this object is link. The table sits between PN_REC_AGR_LINES_ALL (the agreement line) and PN_REC_ARCL_ALL (the area class), carrying foreign keys to both parents plus the ORG_ID operating unit discriminator. This structure mirrors a classic many-to-many linking pattern, making it a natural candidate for modeling as a link table in a Data Vault or dimensional repository.
Key Information Stored
The table contains 29 documented columns. The most significant are:
- REC_AGR_LINAREA_ID — Surrogate primary key, enforced by PN_REC_AGR_LINAREA_PK and additionally by the unique index PN_REC_AGR_LINAREA_U1. This is the column users search on as "rec_agr_linarea_id."
- REC_AGR_LINE_ID — Foreign key to PN_REC_AGR_LINES_ALL, identifying the parent recovery agreement line.
- AREA_CLASS_ID — Foreign key to PN_REC_ARCL_ALL, identifying the recovery area class being allocated.
- ORG_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, partitioning the row by operating unit for multi-org security.
- START_DATE / END_DATE — Effective dating for the allocation.
- AREA_TYPE — Categorizes how the area is treated for recovery purposes.
- FLOOR_PCT — The recovery percentage applied to the area, a key numeric driver of recovery calculations.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — The standard Oracle EBS descriptive flexfield (DFF) columns, enabling client-specific extension without schema changes.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard audit and WHO columns tracking insert and update metadata.
Note that while REC_AGR_LINAREA_ID is unique and serves as the surrogate key, the true business identity of a row is the combination of REC_AGR_LINE_ID, AREA_CLASS_ID, and the effective dates.
Common Use Cases and Queries
Typical uses include recovering allocated areas for a lease, reporting recovery percentages by tenant, and validating that effective-dated allocations do not overlap. A common join pulls allocation details alongside agreement line and area class descriptions:
- Listing all areas for an agreement line:
SELECT * FROM PN_REC_AGR_LINAREA_ALL WHERE REC_AGR_LINE_ID = :line_id; - Effective-dated lookup:
WHERE TRUNC(SYSDATE) BETWEEN START_DATE AND NVL(END_DATE, SYSDATE+1) - Joining to area classes:
PN_REC_AGR_LINAREA_ALL a JOIN PN_REC_ARCL_ALL c ON a.AREA_CLASS_ID = c.AREA_CLASS_ID - Multi-org restricted reporting: filter by
ORG_IDin all queries to respect operating unit security.
Because this is a link/interior table, direct updates are rare; most maintenance occurs through the Property Manager recovery area setup forms and concurrent programs.
Related Objects
- PN_REC_AGR_LINES_ALL — Parent agreement line; joined on REC_AGR_LINE_ID.
- PN_REC_ARCL_ALL — Recovery area class; joined on AREA_CLASS_ID.
- HR_ALL_ORGANIZATION_UNITS — Operating unit reference; joined on ORG_ID.
- PN_REC_AGR_LINAREA_PK / PN_REC_AGR_LINAREA_U1 — Primary key constraint and unique index on REC_AGR_LINAREA_ID.
- PN Recovery Area setup forms and concurrent programs — The primary UI and batch interfaces that create, update, and consume rows in this table.
-
Recovery Area set up table
-
Recovery Area set up table
-
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.